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 v3.sql is:
CREATE OR REPLACE VIEW v3 AS SELECT c FROM v2 WHERE c < 20; SELECT * FROM test.v3; INSERT INTO v3(c) VALUES (8); INSERT INTO v3(c) VALUES (30);