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

Create a query that shows the 3 most expensive products (ProductName and UnitPrice).

Create a query that shows the 10 most expensive orders (unitprice * quantity is sufficient for the calculation), make sure to output both the OrderID and the total order price.

Create a query that finds the CompanyName of all the customers that did not buy anything in 1998.

Create a query that finds the average price all products that are of type Seafood, label the output field as AvgSeafoodPrice (note this is now a multi-table query).

Create a query that returns the first and last name of each employee and a count of how many orders they have placed.