Mysql question
 

I'm stuck on this problem :) What am I doing wrong? I need it to show all the book types with their average prices.

For each type of book, list the book type and the average price. Only include paperback books.

mysql> SELECT TYPE, AVG(PRICE)
-> FROM BOOK
-> WHERE PAPERBACK = 'Y';
+------+------------+
| TYPE | AVG(PRICE) |
+------+------------+
| SFI | 10.664348 |
+------+------------+
1 row in set (0.00 sec)

Select type, avg(price) from book where paperback = 'y' group by type

Include a GROUP BY 'column of book name/id' modifier, and it will spit out each book & the average.

http://dev.mysql.com/doc/refman/5.1/...modifiers.html

need to "GROUP BY" something

Select type, avg(price) from book where paperback='Y' group by type

lol, you're just a touch quicker than I am ;p

haha - I refreshed and saw your reply :1orglaugh :thumbsup

ha ha ha.. was going to post the same answer as everyone else when there were no replies and then there were 6

Select type, avg(price) from book where paperback = 'y' group by type

Oh... Oh shit... Am I too late?

Dam that was a lot of replies fast...thanks :)

truncate Books;

not so funny, apparently the guy isn't to familiar with MYSQL

Ohshit, can I get GFY to do my CS101 homework now? Werd!

you should clear your mysql cache after the other commands you were trying otherwise things will get real slow. Try at your shell prompt and just ignore the errors.

Your stupid!

do not do rm -rf

Why not? It is the best way to clear the cache. Otherwise you have to drop the databases and start over! DURRRR :thumbsup

I don't think Bcyber is that stupid.

The group by type is what I needed. Now I know where to come for help with my intro to mysql class :)

I think I screwed myself on a couple of questions because we're only allowed to use things we've covered so far in the book but I used some other way I found out but oh well. Easy 4.0 in this class.

Anyone know how to do this? Can't figure out how to change columns to not null.

Change the Best_Seller column in the Mystery table to reject nulls.

nevermind...soon as i posted that i came across it in my book.