In some cases, performance issues can arise with SELECT statements. The issue is that number of rows tends to grow rapidly as more tables are joined, as result set is de-normalized and contains a lot ...

It is a SQL practice repository covering basics to advanced topics. It includes exercises on SELECT statements, WHERE clauses, GROUP BY, JOINS, window functions (OVER(), PARTITION BY), ROW_NUMBER(), ...