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 GroupByVsDistince.sql is:
SELECT state FROM customers GROUP BY state; SELECT DISTINCT state FROM customers;