Reference no: EM13829350
Problem:
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.
Additional Information:
The question is from Computer Science and it explains about writing SQL queries for retrieving data in TSQL.
Total Word Limit: 338 Words
|
Create one method that the server takes a piece of code
: Create one method that the server takes a piece of code or data from the user client-side, manipulates it server side after post back, and then provides the manipulated data back to the user.
|
|
What is the principal source of legislative guidance
: 1. What is the principal source of legislative guidance that provides "Special Rules for Long-Term Contracts"? 2. What are the three terms that the IRS uses to define "long-term contract" and what do they mean? 3. What two categories does Sectio..
|
|
What is the difference between prejudice and bias
: What is the difference between prejudice and bias? What is the difference between prejudice and discrimination? Is Shelly showing prejudice, bias, or discrimination in the scenario above
|
|
Sql dml for data modification in tables
: Write SQL DML statements that will modify data from within a database. Using the Northwind database, write a SQL DML statement that will modify the data. Base it on the following requirements:
|
|
Write queries to retrieve data for tsql
: 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:
|
|
Operating system provides a mechanism for configuring
: Operating system provides a mechanism for configuring the behavior of the keyboard attached to the computer. Outline the behavior of the following sets of keys after they have been configured correctly
|
|
Draft paper highlighting the nonfunctional requirements
: draft paper highlighting the nonfunctional requirements and the steps to achieve these requirements. The draft should have some rationalization steps in how technologies are chosen.
|
|
Determine the type of muscle tissues
: The image below shows a longitudinal view of a type of muscle. Note the multiple nuclei that lie at the periphery of the muscle fibers as well as the striations (thin lines) formed by the arrangement of the thick and thin myofilaments.
|
|
What does he mean by internalize society values
: What does he mean by "internalize society's values"? List activities that can assist you in "internalizing the values"
|