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 orderTotalByYear.sql is:
SELECT YEAR(orderDate) AS year, SUM(quantityOrdered * priceEach) AS total FROM orders INNER JOIN orderdetails USING (orderNumber) WHERE status = 'Shipped' GROUP BY YEAR(orderDate) ;