SELECT role_description FROM ROLES WHERE role_code  =  (SELECT role_code FROM users WHERE user_login  =  1 GROUP BY role_code ORDER BY count(*) DESC LIMIT 1)
Find the description of the most popular role among the users that have logged in.
SELECT role_description FROM ROLES WHERE role_code = ( SELECT role_code FROM users WHERE user_login = 1 GROUP BY role_code ORDER BY count ( * ) DESC LIMIT 1 )
select role_description from roles where role_code = ( select role_code from users where user_login = value group by role_code order by count ( * ) desc limit value )
Find the description of the most popular role among the users that have logged in .