Part-B ( 5 Points ) 1) Setup the Bike Store database in your SQL developer (1 points) 2) Display a list of all sales ord
Posted: Mon Jun 06, 2022 2:17 pm
Part-B ( 5 Points ) 1) Setup the Bike Store database in your SQL
developer (1 points)
2) Display a list of all sales orders with staff id is 9 (1
Point)
3) Name all the customers who live in New York and provided a
phone number. (1 point)
4) Display the names of the customers who ordered from Baldwin
Bikes and Santa Cruz Bikes stores. (1 point)
5) Display the name of the items_id and Item name whose discount
is more than 0.05 (1 point)
developer (1 points)
2) Display a list of all sales orders with staff id is 9 (1
Point)
3) Name all the customers who live in New York and provided a
phone number. (1 point)
4) Display the names of the customers who ordered from Baldwin
Bikes and Santa Cruz Bikes stores. (1 point)
5) Display the name of the items_id and Item name whose discount
is more than 0.05 (1 point)