Medium 10 questionsAI-generated
★★★★★★★★★★Not rated yet

SQL Quiz: joins, GROUP BY and subqueries

Test your intermediate SQL queries: joins, grouping with GROUP BY and HAVING, aggregate functions, NULL values, subqueries, foreign keys, indexes, UNION and LIKE.

Start the quiz Created by lecouze13

Question preview

  1. Which join keeps only the rows that have a match in both tables?
  2. Which query counts the number of clients for each city?
  3. Which clause filters the groups after a GROUP BY, based on an aggregate?

… and 7 more questions to discover by playing.

See questions and answers : SQL & Databases

More SQL & Databases quizzes