Which of the following MySQL query is syntactically correct and most preferred…

PYQ EMRS TGT/PGT (ESSE) 2023

Which of the following MySQL query is syntactically correct and most preferred one?

  1. A.

    SELECT SECTION, COUNT(*) FROM STUDENT

    ORDER BY SECTION

    GROUP BY SECTION

    WHERE MARKS < 33 AND COUNT(*) > 0;

  2. B.

    SELECT SECTION, COUNT(*) FROM STUDENT

    WHERE MARKS < 33

    HAVING COUNT(*) > 0

    GROUP BY SECTION

    ORDER BY SECTION;

  3. C.

    SELECT SECTION, COUNT(*) FROM STUDENT

    WHERE MARKS < 33

    GROUP BY SECTION

    HAVING COUNT(*) > 0

    ORDER BY SECTION;

  4. D.

    SELECT SECTION, COUNT(*) FROM STUDENT

    GROUP BY SECTION

    WHERE MARKS < 33 AND COUNT(*) > 0

    ORDER BY SECTION;

Attempted by 2323 students.

Sign up free to check your answer

Sign up free

Explore the full course: Emrs Cs Tier 2

Loading lesson…