CBSE · 083Class XII · 2022Section A1 mark
Question 5b
7 June 2022 · Computer Science (083)
Write the output of the SQL query: SELECT City, COUNT(*) FROM VACCINATION_DATA GROUP BY City;
Answer
| City | COUNT(*) |
|---|---|
| Delhi | 2 |
| Mumbai | 2 |
| Kolkata | 1 |
Explanation
Groups the data by City and counts the number of records for each city.