Following are the two tables in a MySQL database. (Table Data Provided) Select…

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

Answer: D. SELECT SUBNAME, COUNT (*) FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME; — Correct SQL query: SELECT SUBNAME, COUNT(*) FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME;✅ Correct Option: D Explanation: NATURAL JOIN joins tables…

1. A.

   SELECT SUBNAME, COUNT() FROM SUBJECTS, RESULT GROUP BY SUBNAME;

2. B.

   SELECT SUBNAME, COUNT () FROM SUBJECTS, RESULT ORDER BY SUBNAME;

3. C.

   SELECT SUBNAME, COUNT () FROM SUBJECTS NATURAL JOIN RESULT ORDER BY SUBNAME;

4. D.

   SELECT SUBNAME, COUNT (*) FROM SUBJECTS NATURAL JOIN RESULT GROUP BY SUBNAME;

Attempted by 1284 students.

SELECT SUBNAME, COUNT(*)
FROM SUBJECTS NATURAL JOIN RESULT
GROUP BY SUBNAME;

A video solution is available for this question — log in and enroll to watch it.