As we have seen, SQL queries usually return tables that are different from the ones we have stored in the database.

In our database, tables are normalized and very large, which makes them hard to use. Meanwhile, the tables we get by joining, filtering, and selecting the data we need tend to be much friendlier.

Subqueries let us perform complex queries in