display the major name and the number of students in it, we use: a. select count(major_id), major_name from students join majors using(id) group by major_name; b. select count(18), major_name from students join majors using(major_id) group by major_name; c. select count(major_id), major_name from students join majors using(major_id) group by major_name; O d. select count(major_id), major_name for students join majors using(major_id) group by major_name; Majors: DEPARTMENT VAPE Sopoter seience 12 corputer networks computer science computer science Engineering and IT 26 Computer systems en 1gineering 2 electrical enigneering computer systems enigineering Engineering and II computer systems enigineering Engineering and IT