K Kizspy.me
5 of 5
Paper No: 1
Picture 5.1
Question 6:
[1 mark] Write a query to find the customer names and order IDs with a total quantity
purchased greater than or equal to 10 in the year 2020
employee_name
Eminem
order_id
1
total
10
Picture 6.1
Question 7:
[1 mark] Write a query to retrieve information about products that have a price lower than
the average selling price of that product.
product_id product_name
product_name product_price
Zoom
+ 100%
Close
