Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL
This short article shows a simple example of how to generate completely random sample output from a Dataset