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 OrderTotadForYear_with_HAVING.sql is:
SELECT YEAR(orderDate) AS year, SUM(quantityOrdered * priceEach) AS total FROM orders INNER JOIN orderdetails USING (orderNumber) WHERE status = 'Shipped' #AND YEAR(orderDate) > 2003 # Can be used instead of HAVING, but the alias name cannot be used here. GROUP BY year HAVING year > 2003; #HAVING can use the alias and is therefore simpler and more clear.