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 |
|
ahmadsa
Starting Member
7 Posts |
 Posted - 2007-12-12 : 14:13:48
|
| ORDNO LINE_CATPROD_NO QTY PRICE0001 1 P001 2 18.990001 3 P007 3 15.150002 2 P003 4 24.420003 1 P005 5 75.150003 3 P002 6 10.020004 2 P004 7 1.840005 1 P001 8 36.450005 2 P010 3 3.990005 3 P009 2 13.280006 1 P007 4 5.600006 1 P006 2 0.750006 2 P001 10 58.05Using the ORDER_LINE table, write a SQL query to list for each product number, the Total Quantity and the Average Price for all orders. Round the Average Price to the nearest pound and name the columns headings appropriately.can anybody help me with this please i have been trying to figure this out but no luck thanx |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
ahmadsa
Starting Member
7 Posts |
Posted - 2007-12-12 : 14:23:54
|
| i am just going throught my notes and found some questions as apart of an old exercise |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-12 : 20:38:54
|
what have you tried ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
sql query help