SQL Exercise 2:
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) Checklist all product IDs and product names in class three.
2) Discover the utmost, minimal, and common costs of merchandise in class 2.
three) Discover the variety of prospects from every nation.
four) Discover the variety of orders processed by every worker.
5) Discover the workers whose background are associated to psychology.
6) Insert a brand new row into the desk shippers supplying information for all columns.
7) Give all merchandise a three% value enhance.
eight) Give all merchandise in class 2 a 5% value lower.
9) Delete all merchandise from provider eight.
10) Discover all prospects who haven’t positioned any order.
11) Discover the variety of product classes provided by every provider.
12) For every product class, discover the variety of suppliers.
13) Checklist full particulars of all prospects who positioned an order in 1997 February.
14) Checklist all particulars of shippers that shipped the orders positioned by customerID 5.
15) For every class of merchandise with greater than six merchandise, discover the variety of merchandise.
16) Checklist names of all merchandise which have been ordered greater than 100 models completely.
—–
SQL Exercis 2: 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) Checklist the entire product IDs and names in class three.
2) Decide the best, lowest, and common costs of merchandise in class 2.
three) Decide the full variety of prospects from every nation.
four) Decide the variety of orders accomplished by every worker.
5) Establish staff with a background in psychology.
6) Add a brand new row to the desk shippers, filling within the blanks for all columns.
7) Enhance the worth of all merchandise by three%.
eight) Scale back the worth of all merchandise in class 2 by 5%.
9) Take away all merchandise from the provider’s stock eight.
10) Find all prospects who’ve but to put an order.
11) Find
