Find the description of the most popular role among the users that have logged in.
CREATE TABLE users (role_description VARCHAR, role_code VARCHAR, user_login VARCHAR); CREATE TABLE ROLES (role_description VARCHAR, role_code VARCHAR, user_login VARCHAR)
SELECT role_description FROM ROLES WHERE role_code = (SELECT TOP 1 role_code FROM users WHERE user_login = 1 GROUP BY role_code ORDER BY COUNT(*) DESC)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE users (role_description VARCHAR, role_code VARCHAR, user_login VARCHAR); CREATE TABLE ROLES (role_description VARCHAR, role_code VARCHAR, user_login VARCHAR) Question: Find the description of the most popular role among the users that have logged in. [/INST] SELECT role_description FROM ROLES WHERE role_code = (SELECT TOP 1 role_code FROM users WHERE user_login = 1 GROUP BY role_code ORDER BY COUNT(*) DESC) </s>