K
3 of 4
Kizspy.me
Zoom
Paper No: 1
Question 3:
Find product_id, product_name, model year and list price of all products having model year
is 2018 and list_price is 229.99
1
product_id
274
product_name
model year list_price
2.
275
Trek Precaliber 20 Boy's - 2018 2018
Trek Precaliber 20 Girl's - 2018 2018
229.99
229.99
Picture 3.1
Question 4:
Write a query to display product_name, category_name and list price of all products having
the category_name is Mountain Bikes and list_price smaller than 469.99
product_name
1
Trek 820-2016
category_name list_price
Mountain Bikes 379.99
2
3
Haro Flightline One ST-2017 Mountain Bikes 379.99
Trek 820-2018
Mountain Bikes 379.99
Picture 4.1
Question 5:
Write a query to get product_id, product_name with the sum_quantity of products greater than
75.
+ 100%
1
product_id
61
product_name
sum_quantity
Trek Powerfly 8 FS Plus - 2017
78
Close
