SQL Assignment 2

- Download the script [login to view URL] from the course’s website - Run the script to create the object tables and populate the tables - The script will create four tables: Inventory, Sales, Items, Staff - These tables keep track of sales done from an inventory Q1. 4 Marks List the names of employees that made sales on September 23, 2014. a. Using standard syntax b. Using syntax 1999 Q2. 3 Marks Display the name of McLester’s supervisor a. Using standard syntax Q3. 4 Marks Which items are part of order number 020011? Display item name, and sale price a. Using standard syntax b. Using syntax 1999 Q4. 4 Marks Display the total amount on sales and the corresponding commission of Michaels (staff name) a. Using standard syntax b. Using syntax 1999 Q5. 4 Marks Display the total amount in sales made by McLester (staff last name) Format the result to currency and two decimal places. a) Use standard syntax b) Use syntax 1999 Q6. 4 Marks Find all sales done in September. Display order number, sales date and staff member name. a) Use standard syntax b) Use syntax 1999 Q7. 4 Marks Display the number of sales made by Zambini (staff last name). a) Use standard syntax b) Use syntax 1999 Q8. 4 Marks Create a query to calculate all purchases of customer number 100019. The output of this query should be order number, part number, part description, quantity, sale price, and total amount per Item (Format the result to currency and two decimal places). a) Use standard syntax b) Use syntax 1999 Q9. 4 Marks In the table Inventory the items that are discontinued appear under the field name DISCONTINUE with a value of 1. Write a query to find out the Customer number of those customers that have ordered items that have been discontinued. a) Use standard syntax b) Use syntax 1999