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 CounOfOrdersByYear.sql is:
SELECT YEAR(orderDate) AS year, COUNT(orderNumber) FROM orders GROUP BY # year # This works in MySQL but is not standard SQL. YEAR(orderDate) # This works in all SQL databases that follow the standard. ;