Sql database management studio- select statements (week 3)

Using SQL Management Studio Only and using the template with instructions and the database provided, complete tasks below and provide screeen shots in the template.

 

Write SQL statements that will retrieve the following data from a database, using Subqueries and Joins. Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions:

  1. For each order, display the Company Name, City, and the Country for the customer who placed the order.
    • Include the Order Date and the Required Date. Order the results by Company Name in ascending order.
    • 830 rows returned.
  2. For each order, list the OrderID, Orderdate, Product Name, UnitPrice, Quantity Ordered, and Total Cost. Label the column ‘Product Cost.’
    • For each product (including the discount), only show those orders that were placed in March of 1997.
    • Sort the data by the OrderID, then the Product Name.
    • 77 rows returned.
  3. For each order, display the OrderID, ShipName, and the Employee First and Last Name.
    • Order the results by Employee Last Name in descending order, then by Employee First Name in ascending Order, then by OrderID in ascending order.
    • 830 rows returned.
  4. Modify the first query to list the orders with customer details, but include all customers even if they have not placed an order.
  5. List all customers (include CustomerId and Company Name) who have placed less than 5 orders.
    • Include those customers who have placed 0 orders. Name the count field “OrderCount.”
    • Order by number of placed orders in reverse order.
    • 18 rows returned.
  6. Display the ProductName, and UnitPrice of all products that have a unit price larger than Tarte au Sucre.
    • Order the results by UnitPrice in descending order.
    • 7 rows returned.
  7. Display the Customer Name of all customers who have placed orders in 1996.
    • Order the results by Company Name in ascending order.
    • 67 rows returned.
  8. Display the OrderID of all orders that where placed after all orders placed by Bottom-Dollar Markets.
    • Order the result by OrderID in ascending order.
    • 28 rows returned.
  9. List the Company Name of all U.S.-based customers who are NOT located in the same state (or region) as any of the employees.
    • Order the results by Company Name.
    • 10 rows returned.
  10. Display the Product Names of all products that were placed by customers in CA.
    • Order the result by Product Name in ascending order.
    • Eliminate duplicate rows in the results.
    • 10 Rows Returned.

 

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more