Group by clause

Test

Jugadas 1

Crear copia

Sobre esta actividad

Assessment

Creada por

Vidya Mohan

India

Descarga la versión para jugar en papel

Top 10 resultados

#	Jugador	Acierto	tiempo
1	Anónimo 13 de Agosto de 2026	% 100	03:33

¿Quieres aparecer en el Top 10 de este juego? Inicia sesión para identificarte.

Crea tu propio juego gratis desde nuestro creador de juegos

Compite contra tus amigos para ver quien consigue la mejor puntuación en esta actividad

Crear reto

Verbos irregulares en Inglés

Hélmer González Serrano

Colombia

(311)

Se presentan 10 preguntas, cada una con 4 opciones de respuesta. Seleccione la que considere correcta.
cuanto sabes de Futbol

hugo estay

Chile

(318)

este test esta basado en las diapositivas que pudimos ver con anterioridad, consta de 10 preguntas las cuales tienen alternativas para poder resolverlas.
Cultura general española

Ernest Serret

España

(100)

Responde las siguientes preguntas
Brawl stars preguntas

Carlos Andrés Prieto Rodríguez

Colombia

(164)

Completa todas las preguntas
Tipos de sintagmas (II)

idoia rubio

España

(945)

Actividades interactivas para reconocer los distintos tipos de sintagmas


Group by clauseVersión en línea Assessment por 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 clauseVersión en línea

Assessment

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

Puedes integrar el juego en un LMS compatible con LTI 1.1 o LTI 1.3 como Canvas, Moodle, o Blackboard. De esta manera podrás guardar las puntuaciones automáticamente en el libro de calificaciones de esa plataforma.

Group by clause

Test

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Test

Verbos irregulares en Inglés

Test

cuanto sabes de Futbol

Test

Cultura general española

Test

Brawl stars preguntas

Test

Tipos de sintagmas (II)

Group by clauseVersión en línea

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