Programming Easy

SQL Basics Quiz

SQL (Structured Query Language) is the standard language for working with relational databases, and one of the most consistently in-demand skills in data, backend, and full-stack development. This quiz tests the fundamentals that anyone working with databases needs to know.

Questions cover SELECT statements, filtering with WHERE, sorting with ORDER BY, grouping with GROUP BY, and the different types of JOIN — the concepts that come up in nearly every database query a developer or analyst writes.

From simple queries to multi-table joins, this quiz gives a solid test of SQL fundamentals that apply across MySQL, PostgreSQL, SQLite, and beyond.

Start quiz → Opens in a new tab on Cletica

What This Quiz Covers

  • SELECT statements: choosing columns and using *
  • WHERE clause: filtering rows with conditions
  • ORDER BY: ascending and descending sort
  • GROUP BY and aggregate functions: COUNT, SUM, AVG, MAX, MIN
  • INNER JOIN vs. LEFT JOIN: understanding join types
  • Primary keys and foreign keys in relational databases
  • DISTINCT, LIMIT, and other query modifiers
Sample questions3 of 9 shown
Q1
Which SQL statement is used to retrieve data from a database?
Q2
What does a LEFT JOIN return?
Q3
Which aggregate function returns the number of rows in a result?
Answer all 9 questions on Cletica →

Cletica

Want to create your own quiz?

Build surveys and quizzes, share with anyone, collect responses — free to start.

Try Cletica for free →