1) Create a query called QUERY01 that returns everything from the employees table.

2) Create a query called QUERY02 that returns the companyname, contactname, and contacttitle from the suppliers table

3) Create a query called QUERY03 that returns the companyname, contactname, and contacttitle from the customers table from customers from Spain.

4) Create a query called QUERY04 that returns employees first name, last name, title, and extension alphabetized by last name.

5) Create a query called QUERY05 that returns all products information with a price over $90.

6) Create a query called QUERY06 that returns OrderID and OrderDate for all orders in year 1996.

7) Create a query called QUERY07 that returns OrderID, OrderDate, ShipCountry for all orders in with a ShipCountry of France, Finland, or Poland.

8) Create a query called QUERY08 that returns a count of all orders grouped by ShipCountry.

9) Create a query called QUERY09 that returns all companyname and contactname from customers table that have a company name that starts with the letter R.

Products