K
Kizspy.me
3
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.
1
product_id
61
product_name
sum_quantity
2
64
3
109
Trek Powerfly 8 FS Plus - 2017
Electra Townie Original 7D-2017
Sun Bicycles Cruz 7-Women's-2017
78
82
79
4
188
Trek XM700+ Lowstep-2018
86
5
196
Trek Verve+-2018
79
Picture 5.1
Question 6:
Write a query to get customer_id, Fullname (as Firstname + Lastname), order_date,
order_status of all customers ordered products with order_date in 02/2018.
Question 7:
Zoom
+ 100%
customer_id
Fullname
1
11
Deshawn, Mendoza
order_date
2018-02-09 4
order_status
2
15
Linnie, Branch
2018-02-18 4
3
18
Georgetta, Hardin
2018-02-26 3
Picture 6.1
Close
