Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MUKE YA MUHA
Starting Member
4 Posts |
 Posted - 2012-08-16 : 08:07:19
|
| LAB QUESTIONYou are supporting a database that contains the following tables and columns.Customers CustomerID int CustomerName varchar(100)Products ProductID int ProductName varchar(50) ProductPrice MoneyOrders OrderID int CustomerID int ProductID int Quantity int Discount intYou have been asked to write a query that will retrieve order ID 457 and calculate the actual cost of the order based on the product ordered, the discount value calculated against the product price, and the quantity. You must display the customer name, product name, individual product price, individual discounted price, total price (discounted price * quantity), and quantity. |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2012-08-16 : 08:14:02
|
| Your asking us to do your homework?JimUsers <> Logic |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-08-16 : 08:29:36
|
| Try and write the query, then show us what you have. We can help you fix your query if it is not correct.How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|
|
How will you write this query?