Following are the two tables in a MySQL database. (Table Data Provided) Select…
PYQ KVS TGT/PGT 2023
Following are the two tables in a MySQL database. (Table Data Provided) Select the command from the following options to display subjects (SUBNAME) and number of students registered in that subject in table RESULT. MySQL

- A.
SELECT SUBNAME, COUNT() FROM SUBJECTS, RESULT GROUP BY SUBNAME;
- B.
SELECT SUBNAME, COUNT () FROM SUBJECTS, RESULT ORDER BY SUBNAME;
- C.
SELECT SUBNAME, COUNT () FROM SUBJECTS NATURAL JOIN RESULT ORDER BY SUBNAME;
- D.
SELECT SUBNAME, COUNT (*) FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME;
Attempted by 1473 students.
Sign up free to check your answer
Sign up freeLoading lesson…

