Group by clause

Test

Parties jouées 1

Créer une copie

À propos de cette activité

Assessment

Créé par

Vidya Mohan

India

Téléchargez la version pour jouer sur papier

Top 10 résultats

#	Jeux	Précision	temps
1	Anonyme 13 Août 2026	% 100	03:33

Voulez-vous apparaître dans le Top 10 de ce jeu? Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi

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'.
Practice Quiz - Punnett Square, Variation, and Mutations

Benjamin D Morgan

United States

(14)

Practice Quiz - Punnett Square, Variation, and Mutations
Tissues - Practice Quiz

Benjamin D Morgan

United States

(16)

Tissues - Practice Quiz
Spanish Alphabet Listening

Falkenberg Falkenberg

United States

(88)

Spanish alphabet, listening-based assessment
Photosynthesis vs Cellular Respiration - Practice Quiz

Benjamin D Morgan

United States

(39)

Photosynthesis vs Cellular Respiration - Practice Quiz


Group by clauseVersion en ligne Assessment par 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 clauseVersion en ligne

Assessment

par 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;

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

Group by clause

Test

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Test

UPS 5 Seeing Habits Quiz

Test

Practice Quiz - Punnett Square, Variation, and Mutations

Test

Tissues - Practice Quiz

Test

Spanish Alphabet Listening

Test

Photosynthesis vs Cellular Respiration - Practice Quiz

Group by clauseVersion en ligne

par 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?