SQL practice: joins, GROUP BY and normalization in 15 library-database queries
A review of ERDs, join types, GROUP BY/HAVING, SELECT evaluation order and normalization, then 15 SQL exercises on a library database with the LEFT JOIN, COUNT and non-sargable traps.