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 organization.sql is:
CREATE OR REPLACE VIEW organization AS SELECT CONCAT(E.lastname, E.firstname) AS Employee, CONCAT(M.lastname, M.firstname) AS Manager FROM employees AS E INNER JOIN employees AS M ON M.employeeNumber = E.ReportsTo ORDER BY Manager; ALTER VIEW organization AS SELECT CONCAT(E.lastname,E.firstname) AS Employee, E.email AS employeeEmail, CONCAT(M.lastname,M.firstname) AS Manager FROM employees AS E INNER JOIN employees AS M ON M.employeeNumber = E.ReportsTo ORDER BY Manager;