SELECT user_name ,  password FROM users GROUP BY role_code ORDER BY count(*) DESC LIMIT 1
What are the usernames and passwords of users that have the most common role?
SELECT user_name , password FROM users GROUP BY role_code ORDER BY count ( * ) DESC LIMIT 1
select user_name , password from users group by role_code order by count ( * ) desc limit value
What are the usernames and passwords of users that have the most common role ?