SQL: NORTHWIND

Query #1: Display the customer company name, address, city, region, customer country, employee full name (last name, comma space first name LastName, FirstName) using an alias of FullName, order ID and the order date that meet the following criteria: The employee supervisor is Fuller The order date must be from the month of December customers from the countries of UK, USA, Brazil, or Italy Displayed the result set is by the order date starting with the most current date (latest date) to the oldest date. ** your result set should return 18 rows hint: you will need 3 tables plus a table self-joined to itself

Query #2: Display the customer company name along with the phone number of who have at least one order. You must setup an Outer join. Also, the customers phone number must NOT contain 555 anywhere in the phone number (these are fake phone numbers). Order your results by company name and list each company only once. ** your result set should return 47 rows hint: you can use a group by or distinct

Query #3: Display the following fields: Customers.CustomerID, Customers.CompanyName, Customers Company, Customers.ContactName, Customers.ContactTitle, Orders.OrderID, Orders.OrderDate, [Order Details] ProductID, [Order Details] Quantity, [Order Details] Unit Price, [Order Details] Product Sales (Quantity * Unit Price) Only display the above information if ALL of the following criteria are met: The contact name contains the letter manager anywhere within the contact title The quantity ordered is 10+ 2or more The country must be Brazil or France Order the results by Customer Company Name, Order Date descending. ** your result set should return 123 rows hint: you will need 3 tables

Query #4: Create the following summary query: By Product Name list the following: Category Name Product Name total product sales amount - (Calculated field using the Orders Detail table: UnitPrice * Quantity) total number of products ordered - (the sum of the quantity *10 field within the Order Details table) This should be for all products with a category of Condiments or Beverages and whose order discount is 0. Filter out (remove from result set) products whose total number of products ordered is 300 or greater. ** your result set should return 12 rows hint: this is a group by and you will need 4 tables