This is the full assignment, it uses the TSQL V4 database,

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

2. The country name, number of orders shipped, and total freight cost for each country shipped to. 3. The names of the top 6 countries based on the number of orders shipped. 4. The employee number, full employee name (concatenated together) and number of orders taken by that employee during January and February 2016 for all employees. The list should be in descending order by the number of orders taken. 5. The product ID, name of the product, the number of times ordered, and the total quantity ordered for all products ordered by a customer not from Brazil or Germany. Place the list in alphabetical order by the product name. 6. The names and addresses (address, city, region, postalcode & country concatenated together) of all customers who placed at least two orders during July or August of 2015. 7. The product id, product name and orderdate for all products that were not ordered in September 2015. 8. The Supplier ID, supplier name and total cost of all products from that supplier that have been sold. Place the list in descending order by the amount sold. Do two versions of this query, one that shows all suppliers and one that only shows the top ten suppliers. Page 2 of 2 9. The name and address information for all customers who purchased a product in the Seafood category between August 01 2015 and November 01 2015.