Hello, and welcome to the SQL Practice Set! This package of exercises will help you practice everything you know about basic SQL queries and is perfect for anyone who wants to strengthen their SQL skills. The difficulty of the exercises is roughly the same as in the SQL Basics course. Topics covered include:
SELECTs, aggregate functions (
AVG), grouping and ordering results,
JOINs, and subqueries.
Here's a quick reminder of the basic
SELECT name, age
WHERE age > 18
You select data by using the
SELECT keyword, listing the columns, and then using the
FROM keyword where you tell the database to select data from a given table.
To filter the result of your query, you use the
WHERE keyword and a condition: