1) Use the w3data database, and a query with a GROUP BY to answer the following: There are three compnaies providing shipping services for these products. They are (ShipperName) United Package, Speedy Express, and Federal Shipping. If you order and limit correctly, your GROUP BY should produce one ShipperName and the total number of order shipped. Enter the name of the shipping company that shipped the most product for the supplier (SupplierName) G'day, Mate:________. (Hint) put "G'day, Mate" in double quotes). How many shipments (enter a single number only) were handled by the shipper?

2) Use the w3data database, and a query with a GROUP BY to answer the following: there are 3 companies providing shipping services for these products. They are (ShipperName) United Package, Speedy Express, and Federal Shipping. If you order and limit correctly, your GROUP BY should produce one ShipperName and the total number of orders shipped. Enter the name of the shipping company that shipped the most product for the supplier (SupplierName) Ma Maison_______. How many shipments (single number only) were handled by the shipper?

3) Use the w3data database and INNER JOINS, write a SINGLE QUERY that displays ONLY the fields necessary to answer the following question. JOIN only the tables that are necesary to get the answer (remove extra table JOINSthat you dont need in other words). Your query should produce minimal data needed (distinct information; no duplicate information or extraneous data) and nothing else for the following criteria: Given ProductName="Chocolade" Produce ONE correct supplierName AND identify it on the list:

a) G'day Mate b) Leka Trading c) Pavolva, Ltd. d) Speciality Buscuits, Ltd. e) Zaanse Snoepfabriek f) Tokyo Traders g) Mayumi's h) Norske Meirier i) Bigfoot Breweries

4) Using the w3data database and INNER JOINS, write a SINGLE QUERY that displays ONLY the fields necessary to answer the following question. JOIN only the tables that are necessary to get the answer (remove exta table JOINS that you dont need in other words). Your query should produce minimal data needed (distinct information, no duplication information or extraneous data) and nothing else for the following criteria: Given ProduceName='Filo Mix'

Produce ONE correct supplierName and identify it on the following list: a) G'day Mate b) Leka Trading c) Pavlova, Ltd. d) Speciality Buscuits, Ltd e) Zaanse Snoepfabriek f) Tokyo Traders g) Mayumi's h) Norske Meierier i) Bigfoot Breweries

5) In the context of the w3data database, if you are given a OrderdetailID and asked to determine the CustomerName on the order, select and required tables (only the ones you must have INCLUDING the FROM and all JOINS) you need to JOIN in order to complete the search?

a) suppliers b) categories c) products d) orderdetails e) orders f) customers g) employees h) shippers