Skip to content

Instantly share code, notes, and snippets.

View pmaddi's full-sized avatar

Pranav Maddi pmaddi

View GitHub Profile
0xDbd8306D2957aBf4fb93419Fa05Ec488243d505f
local_db=> select major_most_relevant, role_id from rolepreference where role_id=112;
major_most_relevant | role_id
---------------------+---------
45 | 112
45 | 112
(2 rows)
local_db=> select major, count(*) from student where major=45 group by major;
major | count