Answered step by step
Verified Expert Solution
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:
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 USAStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started