Question
In Northwind database. 6.List the country and the number of orders shipped to each country. Name the column that contains the number of orders, Number
In Northwind database.
6.List the country and the number of orders shipped to each country. Name the column that contains the number of orders, "Number of Orders". Sort the list in alphabetical order by country.
7. List the OrderID, the pre-discount price (name the column "Full Retail Price") for all orders and the final price (name the column "Final Price") for all orders. Display the "Final Price" column with two decimal places. (Hint: Use the orderdetails table. The Discount column in the orderdetails contains the order discount. Example .1 = 10% discount.)
*Any help is greatly appreciated*
Step 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