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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-01 : 08:44:07
|
| John writes "If I have these table listed below in a Microsoft Acess DB(relatoinal) :Customer (CID, Name, Address, City, State, ZipCode, Category)Inventory (ItemID, Description, ListPrice, Cost, QuantityOnHand, Category)Item Category (Category, Description, StoreLocation, Season)Order (OrderID, OrderDate, CID)OrderItem (OrderID, ItemID, Quantity, SalePrice)Which category of customers placed the most orders in February?On average, do customers in Boston get a better discount than customers in Sringfield?Please respond to this e-mail at my e-mail addeess at blo_1134@hotmail.com.Your response is very appreciated. Thanks " |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-01 : 14:37:45
|
| Well John, this question is worded so nice and neatly. It sure looks a lot like a test/homework/interview question. Is it? I sure hope not, because we don't do that sort of work here. And if you'd like our help on a real scenario, we're happy to post responses here on the forum, but we usually don't send personal messages via email. However, if you would like to register here, you can then subscribe to this thread so that you get an email message any time somebody posts a response here. Let us know if we can help you with any real situations you are facing, or if you can provide some substantiation that this is not just a quiz. Thanks for coming by.------------------------GENERAL-ly speaking...Edited by - AjarnMark on 03/01/2002 14:38:32 |
 |
|
|
|
|
|
|
|
problems with sql queries