Given a relation country(name, continent, population) which of the following…

PYQ RPSC Programmer 2013

Given a relation country(name, continent, population) which of the following is a valid SQL statement?

  1. A.

    SELECT continent, population FROM country GROUP BY continent

  2. B.

    SELECT continent, SUM(population) FROM country GROUP BY continent

  3. C.

    SELECT name, population FROM country GROUP BY continent

  4. D.

    SELECT name, SUM(population) FROM country GROUP BY continent

Attempted by 3 students.

Sign up free to check your answer

Sign up free

Explore the full course: Rpsc Programmer

Loading lesson…