gistfile1.txt

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 
-------+-------
(0 rows)