Group by clause

Quiz

Played 1

Create copy

About this activity

Assessment

Created by

Vidya Mohan

India

Download the paper version to play

Top 10 results

#	Player	Accuracy	time
1	Anonymous August 13, 2026	% 100	03:33

Do you want to stay in the Top 10 of this game? Log in to identify yourself.

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

Practice Quiz - Punnett Square, Variation, and Mutations

Benjamin D Morgan

United States

(14)

Practice Quiz - Punnett Square, Variation, and Mutations
Spanish Alphabet Listening

Falkenberg Falkenberg

United States

(87)

Spanish alphabet, listening-based assessment
Tissues - Practice Quiz

Benjamin D Morgan

United States

(16)

Tissues - Practice Quiz
Photosynthesis vs Cellular Respiration - Practice Quiz

Benjamin D Morgan

United States

(39)

Photosynthesis vs Cellular Respiration - Practice Quiz
UPS 5 Seeing Habits Quiz

Heather Bell

United States

(12)

Test your knowledge about the 5 seeing habits discussed in the text 'UPS 5 seeing habits'.


Group by clauseOnline version Assessment by Vidya Mohan 1 The school wants to know the total number of students in the table. Which query is correct? a SELECT COUNT() FROM Student; b SELECT SUM() FROM Student; c SELECT COUNT(Student) FROM Student GROUP BY Student; d SELECT NUMBER() FROM Student; 2 The school wants to know how many students are from Kochi. Which query is correct? a SELECT COUNT() FROM Student WHERE City = 'Kochi'; b SELECT COUNT() FROM Student GROUP BY City = 'Kochi'; c SELECT COUNT() FROM Student HAVING City = 'Kochi'; d SELECT COUNT() FROM Student; 3 The school wants to know the number of students from each city. Which query is correct? a SELECT City, COUNT() FROM Student GROUP BY City; b SELECT City, COUNT() FROM Student HAVING City; c SELECT CITY,COUNT() FROM Student; d SELECT City, SUM() FROM Student GROUP BY City; 4 The school wants to display only those cities having more than one student. Which query is correct? a SELECT City, COUNT() FROM Student GROUP BY City HAVING COUNT() > 1; b SELECT City, COUNT() FROM Student WHERE COUNT() > 1 GROUP BY City; c SELECT City, COUNT() FROM Student HAVING COUNT() > 1; d SELECT City, COUNT() FROM Student HAVING City > 1;

Group by clauseOnline version

Assessment

by Vidya Mohan

The school wants to know the total number of students in the table. Which query is correct?

SELECT COUNT(*) FROM Student;

SELECT SUM(*) FROM Student;

SELECT COUNT(Student) FROM Student GROUP BY Student;

SELECT NUMBER(*) FROM Student;

The school wants to know how many students are from Kochi. Which query is correct?

SELECT COUNT(*) FROM Student WHERE City = 'Kochi';

SELECT COUNT(*) FROM Student GROUP BY City = 'Kochi';

SELECT COUNT(*) FROM Student HAVING City = 'Kochi';

SELECT COUNT(*) FROM Student;

The school wants to know the number of students from each city. Which query is correct?

SELECT City, COUNT(*) FROM Student GROUP BY City;

SELECT City, COUNT(*) FROM Student HAVING City;

SELECT CITY,COUNT(*) FROM Student;

SELECT City, SUM(*) FROM Student GROUP BY City;

The school wants to display only those cities having more than one student. Which query is correct?

SELECT City, COUNT(*) FROM Student GROUP BY City HAVING COUNT(*) > 1;

SELECT City, COUNT(*) FROM Student WHERE COUNT(*) > 1 GROUP BY City;

SELECT City, COUNT(*) FROM Student HAVING COUNT(*) > 1;

SELECT City, COUNT(*) FROM Student HAVING City > 1;

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

Group by clause

Quiz

About this activity

Created by

Download the paper version to play

Top Games

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

Spanish Alphabet Listening

Quiz

Tissues - Practice Quiz

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

UPS 5 Seeing Habits Quiz

Group by clauseOnline version

by Vidya Mohan

The school wants to know the total number of students in the table. Which query is correct?

The school wants to know how many students are from Kochi. Which query is correct?

The school wants to know the number of students from each city. Which query is correct?

The school wants to display only those cities having more than one student. Which query is correct?