NOTES

• Use the ShoppingManagement database (Ass5.txt) which is available in the ITC114 subject Interact site.

Write and run SQL statements to complete the following tasks:

1. Show the details of the employee/s where the manager (emp_mrg) of the employee is 100 and age of the employee at hire date is greater than 30 (3 marks),

2. Show the managers (emp_mrg) and the number of employees under each manager (2 marks),

3. Show the manager (emp_mgr) who has the highest the number of employees (2 marks),

4. Show the customer code (cus_code) whose total investment (inv_total) is greater than 100 and less than 1000 (2 marks),

5. Show the customer details who has the highest investment (inv_total) (2 marks),

6. Show the details of the products where the minimum price of the product is less than 20 and the vender code (v_code) is 21225 (2 marks),

7. Show the product details that has the highest line price (line_price) (3 marks).

You are required to submit:

1. The SQL statements for each query, which should be copied and pasted into your submission file.

2. The screenshots of the results of the SQL statements should be copied and pasted into your submission file immediately after you execute the SQL query.