Examples and Notes by Week

↑ Up to Parent directory
View CounOfOrdersByYear.sql code.	Open/Save CounOfOrdersByYear.sql.
View GroupByNeedsOrderBy.sql code.	Open/Save GroupByNeedsOrderBy.sql.
View GroupByVsDistince.sql code.	Open/Save GroupByVsDistince.sql.
View OrderTotadForYear_with_HAVING.sql code.	Open/Save OrderTotadForYear_with_HAVING.sql.
View OrderTotalWithHaving.sql code.	Open/Save OrderTotalWithHaving.sql.
View OrderTotalWithHavingAnd.sql code.	Open/Save OrderTotalWithHavingAnd.sql.
View orderTotalByStatus.sql code.	Open/Save orderTotalByStatus.sql.
View orderTotalByYear.sql code.	Open/Save orderTotalByYear.sql.
View orderTotals.sql code.	Open/Save orderTotals.sql.
View status.sql code.	Open/Save status.sql.

The code for status.sql is:
SELECT status, COUNT(*) AS 'Count' FROM orders GROUP BY status ORDER BY status;