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 vps.sql is:
# DROP VIEW IF EXISTS vps; # DROP not needed with CREATE OR REPLACE VIEW CREATE OR REPLACE VIEW vps AS SELECT employeeNumber, lastName, firstName, jobTitle, extension, email, officeCode, reportsTo FROM employees WHERE jobTitle LIKE '%VP%' WITH CHECK OPTION;