Examples and Notes by Week

↑ Up to Parent directory
View aboveAvgProducts.sql code.	Open/Save aboveAvgProducts.sql.
View bigSalesOrder.sql code.	Open/Save bigSalesOrder.sql.
View customerOrders.sql code.	Open/Save customerOrders.sql.
View customerPayments.sql code.	Open/Save customerPayments.sql.
View officeInfo.sql code.	Open/Save officeInfo.sql.
View organization.sql code.	Open/Save organization.sql.
View salePerOrder.sql code.	Open/Save salePerOrder.sql.
View v1.sql code.	Open/Save v1.sql.
View v2.sql code.	Open/Save v2.sql.
View v2_altered.sql code.	Open/Save v2_altered.sql.
View v3.sql code.	Open/Save v3.sql.
View vps.sql code.	Open/Save vps.sql.

The code for aboveAvgProducts.sql is:
DROP VIEW IF EXISTS aboveAvgProducts; CREATE VIEW aboveAvgProducts AS SELECT productCode, productName, buyPrice FROM products WHERE buyPrice > ( SELECT AVG(buyPrice) FROM products) ORDER BY buyPrice DESC;