Question: 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:

Use northwind database to answer the following questions: 4. NorthWind traders wants

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!