Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use northwind database to answer the following questions: 4. NorthWind traders wants to know the following information about their orders for products supplied by Supplier

Use northwind database to answer the following questions:

image text in transcribed

4. NorthWind traders wants to know the following information about their orders for products supplied by Supplier number 12 and fulfilled by employee number 2 The first and last name of the employee who took the order b. The customer name (Company Name) of the customer who placed the order C. The Orderld and the ShippedDate. d. The Productid and Product Name of the item(s) ordered e. The Suppliers and Company Name of the supplier f. The Shipperld and Company Name of the Shipper. Sort the output by OrderDate then by CustomerID. Since several of the fields use the same name use column aliases where needed to differentiate between the columns with the same names 5. List the Orderld, CustomerID, Order Date, UnitPrice and Quantity for all orders with a quantity under 12. Use Correlation names. 6. Use the UNION keyword to return 2 columns from the Customers table, Company Name and Country. If the Country is USA the country value should be "Inside USA". Otherwise the country value should be "Outside USA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Medical Image Databases

Authors: Stephen T.C. Wong

1st Edition

1461375398, 978-1461375395

More Books

Students also viewed these Databases questions