Join a sub query with group by statement

Find members that have the same password

More Advanced – Get minimum member ID from members that have same password:

 

Reference: