In Microsoft SQL Server Management Studio

1. Write a query, using a join, to display the customers company name, orders order date, and the employees last name for all orders in the orders table. (This query will return 830 rows)

2. Write a query, using a join, to display the orders order date, the orders details quantity, and the products product name for all orders in the orders table. (This query will return 2155 rows)

3. Write a query, using a join, to display the products product name, the categorys category name, and the sum of all the order details quantity for all the orders in the order details table. Base the summation on product name and the category name. Sort the results from highest summation value to the lowest summation value. (This query will return 77 rows)

4. Write a query, using a join, to display the employees last name, the territorys territory description, and the regions region description for each employee in the employee table. Sort the results by the employees last name. (This query will return 49 rows)

5.Use a UNION operator to generate a result set consisting of two columns from the Suppliers table: CompanyName, and Country. If the vendor is in USA, the country value should be USA; otherwise, the country value should be Outside USA. Sort the final result set by country. (This query will return 29 rows)