K
Kizspy.me
Zoom
[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 total
1
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
1
product_name
Mouse
product_price
20
Picture 7.1
Question 8:
[0.5 mark] Write a query to increase the price in the product table by 10% if the current price
is lower than the selling price (increase only once even if the product has been sold multiple
times).
+ 100%
Close
