SELECT user_name ,  password FROM users GROUP BY role_code ORDER BY count(*) DESC LIMIT 1
List all the username and passwords of users with the most popular 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
List all the username and passwords of users with the most popular role .