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 salePerOrder.sql is:
DROP VIEW IF EXISTS salePerOrder; CREATE VIEW salePerOrder AS SELECT orderNumber, SUM(quantityOrdered * priceEach) total FROM orderDetails GROUP by orderNumber ORDER BY total DESC;