Using the TSQLv4 database that is installed on your computer. You will again need to look at the tables to figure out which ones you need to use. Write the following queries

1. List the product ID, product name, and the total dollar amount for all items that were shipped to customers in the USA. Use a correlated query. 2. List the order ID, order date, employee ID, employee last name, customer ID, and company name for all orders that contain at least one item from the Beverages category. Use the category name in your query and use the Exists predicate 3. Write a stored procedure to do the query in problem 1, accepting the country name as a parameter. After testing the procedure, script it into a file for submission. 4. Write a stored procedure to do the query in problem 2, accepting the category name as a parameter. After testing the procedure, script it into a file for submission. 5. List the order ID, order date, customer ID, and company name for all orders that fail to contain at least one item from the Confections category. 6. Write a stored procedure to solve problem 5, accepting the category name as a parameter.