Description
- Load the tables for lab 2 into your Oracle account:
Run a script called ORDERS to get this lab2 table into your Oracle account. (1 Mark)
Run a script called CUSTOMERS to get this lab2 table into your Oracle account. (1 Mark)
Run a script called ORDERDETAILS to get this lab2 table into your Oracle account. (1 Mark)
- Make the font size 22 so your instructor can see it. (1 mark)
Your instructor will happily show you this and award you a mark if you are not successful doing this.
- Determine the average quantity ordered by processing all the orderliness in the ORDERDETAILS table. (1 or 2 marks)
For 1 mark
For 2 marks
- Show the order number and number of orderliness in each order from the order with the most lines down to the order with the least number of lines. (1 mark)
- Provide an join of CUSTOMERS and ORDERS that only contains matching rows like below. (1 mark)
- Show the total number of orders from each customer city that have more than five orders with the highest and lowest customer credit limit from those customers generating an order based in that city. Sort by the city name. ( 2 marks)
