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;
- A.
3, 70000
- B.
3, 5000
- C.
7, 50000
- D.
3,4000
Attempted by 1931 students.
Sign up free to check your answer
Sign up freeLoading lesson…

