SQL Intermediate Challenge

Test

Parties jouées 4

Créer une copie

À propos de cette activité

Test your SQL skills with these intermediate-level questions!

Créé par

Tony Dominguez Cruz

Dominican Republic

Téléchargez la version pour jouer sur papier

Top 10 résultats

#	Jeux	Précision	temps
1	NN 5 Juillet 2025	% 100	01:18

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


SQL Intermediate ChallengeVersion en ligne Test your SQL skills with these intermediate-level questions! par Tony Dominguez Cruz 1 What SQL clause is used to filter records? a SELECT b GROUP BY c WHERE d ORDER BY 2 Which SQL function is used to count rows? a SUM() b COUNT() c MAX() d AVG() 3 What keyword is used to remove duplicates in SQL? a UNIQUE b DISTINCT c REMOVE d FILTER 4 Which SQL command is used to modify existing records? a INSERT b ALTER c DELETE d UPDATE 5 What is the purpose of the JOIN clause? a Filter data b Combine rows from two or more tables c Aggregate data d Sort data 6 Which type of JOIN returns all records from the left table? a LEFT JOIN b FULL JOIN c RIGHT JOIN d INNER JOIN 7 What does the GROUP BY clause do? a Sorts rows b Filters rows c Groups rows sharing a property d Joins tables 8 Which SQL function calculates the average value? a COUNT() b SUM() c MEDIAN() d AVG() 9 What is a subquery? a An aggregate function b A data type c A query within another query d A type of JOIN 10 Which SQL statement is used to create a new table? a CREATE TABLE b NEW TABLE c ADD TABLE d INSERT TABLE

SQL Intermediate ChallengeVersion en ligne

Test your SQL skills with these intermediate-level questions!

par Tony Dominguez Cruz

What SQL clause is used to filter records?

SELECT

GROUP BY

WHERE

ORDER BY

Which SQL function is used to count rows?

SUM()

COUNT()

MAX()

AVG()

What keyword is used to remove duplicates in SQL?

UNIQUE

DISTINCT

REMOVE

FILTER

Which SQL command is used to modify existing records?

INSERT

ALTER

DELETE

UPDATE

What is the purpose of the JOIN clause?

Filter data

Combine rows from two or more tables

Aggregate data

Sort data

Which type of JOIN returns all records from the left table?

LEFT JOIN

FULL JOIN

RIGHT JOIN

INNER JOIN

What does the GROUP BY clause do?

Sorts rows

Filters rows

Groups rows sharing a property

Joins tables

Which SQL function calculates the average value?

COUNT()

SUM()

MEDIAN()

AVG()

What is a subquery?

An aggregate function

A data type

A query within another query

A type of JOIN

Which SQL statement is used to create a new table?

CREATE TABLE

NEW TABLE

ADD TABLE

INSERT TABLE

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.

SQL Intermediate Challenge

Test

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Test

Tissues - Practice Quiz

Test

Practice Quiz - Punnett Square, Variation, and Mutations

Test

Photosynthesis vs Cellular Respiration - Practice Quiz

Test

Spanish Alphabet Listening

Test

UPS 5 Seeing Habits Quiz

SQL Intermediate ChallengeVersion en ligne

par Tony Dominguez Cruz

What SQL clause is used to filter records?

Which SQL function is used to count rows?

What keyword is used to remove duplicates in SQL?

Which SQL command is used to modify existing records?

What is the purpose of the JOIN clause?

Which type of JOIN returns all records from the left table?

What does the GROUP BY clause do?

Which SQL function calculates the average value?

What is a subquery?

Which SQL statement is used to create a new table?

		%
	Anonyme	%
		%
		%