Sql Tips

1. FROM generates the data set
2. WHERE filters the generated data set
3. GROUP BY aggregates the filtered data set
4. HAVING filters the aggregated data set
5. SELECT transforms the filters aggregated data set
6. ORDER BY sorts the transformed data set
7. LIMIT .. OFFSET frames the sorted data set