SQL Exercise 1:
Name___________________Student No._______________________
Go to the next hyperlink and kind SQL statements to complete the next questions.
https://www.w3schools.com/SQL/trysql.asp?filename=trysql_op_in
1) Record full particulars of all buyer whose nation is UK.
2) Record all merchandise’ ID with their provider ID and class ID.
three) Record all shipper IDs in all orders.
four) Record all shipper IDs in all orders, with duplicates eradicated.
5) Show the full amount of product 51 in all orders.
6) Record IDs and names for all prospects whose first identify of their contact identify is ‘Elizabeth’.
7) Record all suppliers in UK or USA.
eight) Record the IDs of all orders whose amount is a minimum of 40.
9) Record all merchandise, organized in descending order of value.
10) Produce a listing of orders so as of amount. If amount is similar for some orders, then kind by product ID.
11) Discover what number of merchandise whose ID is 51 are ordered completely.
12) Discover what number of orders that ordered product 71.
13) Discover the common value of the merchandise in class 2.
14) Discover what number of merchandise whose costs is between 10 and 30, and the sum of their costs.
15) Discover the variety of orders positioned in August 1996.
16) Record the small print of the costliest product in class 2.
17) Discover the very best value, the bottom value, and the common value of merchandise in class three.
18) Discover the variety of USA suppliers.
19) Discover what number of orders are shipped by shipper 2 in 1997.
20) Discover the small print of the order that has the minimal amount.
——
SQL Exercise No. 1: Name_____________________
To reply the next questions, go to the next hyperlink and kind SQL statements.
https://www.w3schools.com/SQL/trysql.asp?filename=trysql op in
1) Compile a listing of all prospects whose residence nation is the UK.
2) Record the IDs of all merchandise, together with their provider IDs and class IDs.
three) Embody all shipper IDs in each order.
four) Embody all shipper IDs in all orders, eradicating duplicates.
5) In all orders, present the full amount of product 51.
6) Make a listing of all prospects whose first identify of their contact identify is ‘Elizabeth.’
7) Make a listing of all suppliers in the UK or the US.
eight) Record the IDs of all orders with a amount of not less than 40.
9) Organize all merchandise in descending value order.
10) Create a
