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 |
|
zywiec-zdroj
Starting Member
2 Posts |
 Posted - 2012-02-19 : 14:14:14
|
| Hi All,I have a database of CDs.I have a table of few columns containing id, name, amount price and version. Tasks:1.Write the number of discs of any kind.2. Calculate the average price of a book of any kind. Calculate the average price of a book about identifier of the type first3. Calculate the average price of the book of the kind which are at least 3 pieces.Please help me out in these queries. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-19 : 14:33:36
|
| Homework?Show what you have so far and explain where you're stuck.--Gail ShawSQL Server MVP |
 |
|
|
zywiec-zdroj
Starting Member
2 Posts |
Posted - 2012-02-19 : 14:38:51
|
| These are individual questions.We have 20 homework. I did have half, and those can not. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-19 : 16:47:52
|
| I'm not doing your homework for you, I don't need the practice and you don't learn anything if I do.Post the table structures (because the details you gave are not sufficient and only apply to the first question), show what you have tried for each and explain where you are stuck.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Basic Queries T-SQL