pmaddi

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 

pmaddi

0xDbd8306D2957aBf4fb93419Fa05Ec488243d505f