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

image.png
  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 1473 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…