Práctica SQL – Subconsultas

Line Up

Played 20

Create copy

About this activity

Práctica SQL – Subconsultas

Created by

Fabricio Moreira cerdas

Costa Rica

Download the paper version to play

Top 10 results

#	Player	Accuracy	time
1	Fabricio Moreira cerdas May 8, 2026	% 100	03:23
2	alexadra May 8, 2026	% 81	03:55

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

Chronicles of Dreams (The Arabian Nights)

Cristina Bataller

United States

(3)

In this game, players must correctly order the events from 'The Dream' in the Tales of Arabian Nights based on the sequence of events as they unfold in the narrative.
Board Games

Educaplay Educational Resources

Spain

(466)

Can you arrange these board games from the oldest to the most recent?
Digestive System

Holly Hanna

United States

(10)

Put the steps in digestion in the correct order.
Blood Circulation & Conduction System

Keng Chi

Malaysia

(9)

In this game, players must correctly order the stages of blood circulation & conduction system in the human body. The objective is to understand how blood flows through the heart, lungs, and body; and...


Práctica SQL – SubconsultasOnline version Práctica SQL – Subconsultas by Fabricio Moreira cerdas 1 Mostrar el nombre de los estudiantes usando un alias llamado Estudiante. FROM nombre AS Estudiantes SELECT Estudiante 2 Mostrar el promedio usando un alias llamado Nota_Final. SELECT promedio AS Estudiantes Nota_Final FROM 3 Mostrar el estudiante con el promedio más alto. SELECT MAX(promedio) FROM Estudiantes ( Estudiantes = FROM ); nombre WHERE SELECT promedio 4 Mostrar estudiantes que tengan un promedio mayor al promedio general. SELECT WHERE ( ); promedio SELECT AVG(promedio) FROM Estudiantes nombre, promedio > 5 Mostrar estudiantes que sí tienen cursos registrados usando EXISTS. SELECT SELECT * FROM Cursos C WHERE E.id_estudiante = C.id_estudiante FROM nombre Estudiantes ); WHERE E EXISTS (

Práctica SQL – SubconsultasOnline version

Práctica SQL – Subconsultas

by Fabricio Moreira cerdas

Mostrar el nombre de los estudiantes usando un alias llamado Estudiante.

FROM

nombre

Estudiantes

SELECT

Estudiante

Mostrar el promedio usando un alias llamado Nota_Final.

SELECT

promedio

Estudiantes

Nota_Final

FROM

Mostrar el estudiante con el promedio más alto.

SELECT MAX(promedio) FROM Estudiantes

(

Estudiantes

FROM

);

nombre

WHERE

SELECT

promedio

Mostrar estudiantes que tengan un promedio mayor al promedio general.

SELECT

WHERE

(

);

promedio

SELECT AVG(promedio) FROM Estudiantes

nombre,

promedio >

Mostrar estudiantes que sí tienen cursos registrados usando EXISTS.

SELECT

SELECT * FROM Cursos C WHERE E.id_estudiante = C.id_estudiante

FROM

nombre

Estudiantes

);

WHERE

EXISTS

(

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.

Práctica SQL – Subconsultas

Line Up

About this activity

Created by

Download the paper version to play

Top Games

Line Up

Chronicles of Dreams (The Arabian Nights)

Line Up

Board Games

Line Up

Digestive System

Line Up

Blood Circulation & Conduction System

Práctica SQL – SubconsultasOnline version

by Fabricio Moreira cerdas

Mostrar el nombre de los estudiantes usando un alias llamado Estudiante.

Mostrar el promedio usando un alias llamado Nota_Final.

Mostrar el estudiante con el promedio más alto.

Mostrar estudiantes que tengan un promedio mayor al promedio general.

Mostrar estudiantes que sí tienen cursos registrados usando EXISTS.

		%
	Anonymous	%
		%
		%