CREATE TABLE users (user_name VARCHAR, password VARCHAR, role_code VARCHAR)

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 NULLS LAST LIMIT 1