-3.1 Northwinds Calculated Fields. Madison Dewitt 1. List all customer ID's followed by a second column...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
-3.1 Northwinds Calculated Fields. Madison Dewitt 1. List all customer ID's followed by a second column combining customers' company names with their country, in parentheses. Results should look like this: "Alfreds Futterkiste (Germany)" The second column name should be: "Company (Country)" Sort by CustomerID 2. List all orders, with these fields: Order10, Orderbate, CustomerID, then in a single column like above, with "Company Name (Country)" HINT: This requires a 30IN. Sort by OrderDate then Order ID 3. List all product ID's, followed by a second column combining product names with their supplier company name in parantheses. Results should look like this: "Chai (Exotic Liquids)" The second column name should read: "Product (Supplier)" Sort by Productio 4. List all Orders with Products (Suppliers) OrderID, Orderpate, Product ID, then in a single column like above, with "Product Name (Supplier)" HINT: This requires multiple 30INS. Be sure to include all orders. Additional joins can be inner joins. Sort by OrderDate then Product ID -- 5. List Employees, including EmployeeID and a second column combining LastName, FirstName into a single column called Employee In this format: "LastName, FirstName" --Sort by EmployeeID. --6. We want to create new email addresses for each employee - List the EmployeeID for each employee, LastName, FirstName, followed by - a single field named NewEmail in this format: "FirstName.LastNane@Northwinds.com" - Sort by Employee ID. -7. List all Orders, including these fields: OrderID, OrderDate, Employee with "LastName, FirstName" in a single column, and NewEmail as constructed above Sort by OrderID 8. Calculate order subtotals per record by calculating Quantity times UnitPrice -Include these fields: OrderID, OrderDate, Product ID, UnitPrice, Discount, plus a new Discount Price column, calculated as UnitPrice (UnitPrice Discount) -9. Add two columns to the above, including Quantity and a new TotalPrice column, calculated as Discount Price times Quantity (NOTE: You will have to re-calculate Discount Price as part of the calculation for the TotalPrice column) -3.1 Northwinds Calculated Fields. Madison Dewitt 1. List all customer ID's followed by a second column combining customers' company names with their country, in parentheses. Results should look like this: "Alfreds Futterkiste (Germany)" The second column name should be: "Company (Country)" Sort by CustomerID 2. List all orders, with these fields: Order10, Orderbate, CustomerID, then in a single column like above, with "Company Name (Country)" HINT: This requires a 30IN. Sort by OrderDate then Order ID 3. List all product ID's, followed by a second column combining product names with their supplier company name in parantheses. Results should look like this: "Chai (Exotic Liquids)" The second column name should read: "Product (Supplier)" Sort by Productio 4. List all Orders with Products (Suppliers) OrderID, Orderpate, Product ID, then in a single column like above, with "Product Name (Supplier)" HINT: This requires multiple 30INS. Be sure to include all orders. Additional joins can be inner joins. Sort by OrderDate then Product ID -3.1 Northwinds Calculated Fields. Madison Dewitt 1. List all customer ID's followed by a second column combining customers' company names with their country, in parentheses. Results should look like this: "Alfreds Futterkiste (Germany)" The second column name should be: "Company (Country)" Sort by CustomerID 2. List all orders, with these fields: Order10, Orderbate, CustomerID, then in a single column like above, with "Company Name (Country)" HINT: This requires a 30IN. Sort by OrderDate then Order ID 3. List all product ID's, followed by a second column combining product names with their supplier company name in parantheses. Results should look like this: "Chai (Exotic Liquids)" The second column name should read: "Product (Supplier)" Sort by Productio 4. List all Orders with Products (Suppliers) OrderID, Orderpate, Product ID, then in a single column like above, with "Product Name (Supplier)" HINT: This requires multiple 30INS. Be sure to include all orders. Additional joins can be inner joins. Sort by OrderDate then Product ID -- 5. List Employees, including EmployeeID and a second column combining LastName, FirstName into a single column called Employee In this format: "LastName, FirstName" --Sort by EmployeeID. --6. We want to create new email addresses for each employee - List the EmployeeID for each employee, LastName, FirstName, followed by - a single field named NewEmail in this format: "FirstName.LastNane@Northwinds.com" - Sort by Employee ID. -7. List all Orders, including these fields: OrderID, OrderDate, Employee with "LastName, FirstName" in a single column, and NewEmail as constructed above Sort by OrderID 8. Calculate order subtotals per record by calculating Quantity times UnitPrice -Include these fields: OrderID, OrderDate, Product ID, UnitPrice, Discount, plus a new Discount Price column, calculated as UnitPrice (UnitPrice Discount) -9. Add two columns to the above, including Quantity and a new TotalPrice column, calculated as Discount Price times Quantity (NOTE: You will have to re-calculate Discount Price as part of the calculation for the TotalPrice column) -- 5. List Employees, including EmployeeID and a second column combining LastName, FirstName into a single column called Employee In this format: "LastName, FirstName" --Sort by EmployeeID. --6. We want to create new email addresses for each employee - List the EmployeeID for each employee, LastName, FirstName, followed by - a single field named NewEmail in this format: "FirstName.LastNane@Northwinds.com" - Sort by Employee ID. -7. List all Orders, including these fields: OrderID, OrderDate, Employee with "LastName, FirstName" in a single column, and NewEmail as constructed above Sort by OrderID 8. Calculate order subtotals per record by calculating Quantity times UnitPrice -Include these fields: OrderID, OrderDate, Product ID, UnitPrice, Discount, plus a new Discount Price column, calculated as UnitPrice (UnitPrice Discount) -9. Add two columns to the above, including Quantity and a new TotalPrice column, calculated as Discount Price times Quantity (NOTE: You will have to re-calculate Discount Price as part of the calculation for the TotalPrice column)
Expert Answer:
Answer rating: 100% (QA)
To create the calculated fields in Northwind you can use the following SQL queries Query 1 SELECT CustomerID CONCATCompanyName Country AS Company Country FROM Customers ORDER BY CustomerID A single st... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Please explain what is usury? Should interest rates be regulated by the federal or local government. Give reasons to support your answer. 2) When should a minor know better in regards to business...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Convert decimal + 49 and + 29 to binary, using the signed-2's-complement representation and enough digits to accommodate the numbers. Then perform the binary equivalent of ( +29) + (-49), (-29) +...
-
Formaldehyde gives a negative result in the iodoform test. Do you think that the iodoform test could be used to distinguish methyl ketones from all aldehydes? Explain your answer with reference to...
-
The sales life cycle is used to describe the phases a product goes through from introduction to withdrawal from the market. The four phases are: (a) introduction, (b) growth, (c) maturity, and (d)...
-
What situations did Wayne Bremser suggest are active areas for forensic accountants?
-
In recent years, Farr Company has purchased three machines. Because of frequent employee turnover in the accounting department, a different accountant was in charge of selecting the depreciation...
-
Landman Corporation (LC) manufactures time series photographicequipment. It is currently at its target debt-equity ratio of 75.It's considering building a new $41 million manufacturing facility.Thi 2...
-
When a slice of buttered toast is accidentally pushed over the edge of a counter, it rotates as it falls. If the distance to the floor is 65 cm and for rotation less than 1 rev, what are the (a)...
-
Explain how an accrual or Z bond works.
-
Explain the difference between diversified and undiversified VaR.
-
What is the relationship between the value of an MBS and the assumed volatility?
-
What dimension of a floaters price sensitivity do index duration and spread duration measure?
-
How does a collateralized mortgage obligation alter the cash flow from mortgages so as to shift prepayment risk across various classes of bondholders?
-
International brands like H&M are facing changing consumer tastes in China. The shifting tastes of China's millennials and growing popularity of local brands means fast fashion retailers like H&M...
-
Refer to the situation described inBE 18-13, but assume a 2-for-1 stock split instead of the 5% stock dividend. Prepare the journal entry to record the stock split if it is to be effected in the form...
-
Prove that the velocity potential and the stream function for a source flow, Eqs. (3.67) and (3.72), respectively, satisfy Laplace's equation.
-
Consider a velocity field where the x and y components of velocity are given by u = cy/(x2 + y2) and v = cx/(x2 + y2), where c is a constant. Obtain the equations of the streamlines.
-
Consider an oblique shock generated at a compression corner with a deflection angle = 18.2. A straight horizontal wall is present above the corner, as shown in Fig. 9.14. If the upstream flow has...
-
Let \(C\) be the positively oriented ellipse \(3 x^{2}+y^{2}=9\). Define \[F\left(z_{0} ight)=\int_{C} \frac{z^{2}+2 z}{z-z_{0}} d z\] Find \(F(2 i)\) and \(F(2)\). [Sketch the ellipse in the complex...
-
Show that for \(g\) and \(h\) analytic functions at \(z_{0}\), with \(g\left(z_{0} ight) eq 0, h\left(z_{0} ight)=0\), and \(h^{\prime}\left(z_{0} ight) eq 0\),...
-
Show that \[\int_{C} \frac{d z}{(z-1-i)^{n+1}}=\left\{\begin{array}{cc} 0, & n eq 0 \\ 2 \pi i, & n=0 \end{array} ight.\] for \(C\) the boundary of the square \(0 \leq x \leq 2,0 \leq y \leq 2\)...
Study smarter with the SolutionInn App