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

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 FETCH FIRST 1 ROWS ONLY