Examples and Notes by Week

↑ Up to Parent directory
View create_mebesr_committees.sql code.	Open/Save create_mebesr_committees.sql.
View cte.sql code.	Open/Save cte.sql.
View customer_payments.sql code.	Open/Save customer_payments.sql.
View customers_with_no_sales.sql code.	Open/Save customers_with_no_sales.sql.
View derived1.sql code.	Open/Save derived1.sql.
View dervied2.sql code.	Open/Save dervied2.sql.
View fullName.sql code.	Open/Save fullName.sql.
View join.sql code.	Open/Save join.sql.
View join_four.sql code.	Open/Save join_four.sql.
View join_three.sql code.	Open/Save join_three.sql.
View left_join.sql code.	Open/Save left_join.sql.
View order_over_60000.sql code.	Open/Save order_over_60000.sql.
View order_totals.sql code.	Open/Save order_totals.sql.
View right_join.sql code.	Open/Save right_join.sql.
View right_rewritten_as_left.sql code.	Open/Save right_rewritten_as_left.sql.
View subquery1.sql code.	Open/Save subquery1.sql.
View subquery2.sql code.	Open/Save subquery2.sql.
View subquery_corrilated.sql code.	Open/Save subquery_corrilated.sql.
View subquery_from.sql code.	Open/Save subquery_from.sql.
View total_customer_orders.sql code.	Open/Save total_customer_orders.sql.

The code for subquery_from.sql is:
SELECT MAX(items), MIN(items), FLOOR(AVG(items)) FROM (SELECT orderNumber, COUNT(orderNumber) AS items FROM orderdetails GROUP BY orderNumber) AS lineitems;