Use Microsoft SQLServer to make the following queries. You should also download the Pirate Sports DM-DD that gives the fields for every table. Be sure to use proper alignment with your indents. Electronically download this document to enter your results. Once you have formed the query you are to copy and paste your code under the proper Query number below. Also enter your result right after the code.
1) What are the total sales (dollar amount) for all products sold?
2) What are the total sales (dollar amount) for all football products sold?
3) List all clients who do not live in North Carolina that have purchased products. Be sure to illustrate their first and last name as a string.