Find the output of the MySQL query based on the given table COACH (ignore the…

PYQ KVS TGT/PGT 2023

Find the output of the MySQL query based on the given table COACH (ignore the output header).

Table: COACH
CID | CNAME    | GAME     | SALARY
G03 | VSHALI   | NULL     | 60000
G05 | YUVRAJA  | CRICKET  | NULL
G08 | MALKHAN  | ATHLATICS| 80000
G09 | SACINDRA | CRICKET  | NULL

Query:
SELECT COUNT(GAME), AVG(SALARY)
FROM COACH;

  1. A.

    3, 70000

  2. B.

    3, 5000

  3. C.

    7, 50000

  4. D.

    3,4000

Attempted by 1931 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…