Mysql question

[BSleazy]

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)

[georgeyw]

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

[Senior_Spank]

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

[woj]

need to "GROUP BY" something

[sarettah]

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

[sarettah]

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

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

[georgeyw]

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

haha - I refreshed and saw your reply

[Tempest]

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

[Jason Voorhees]

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

[Jason Voorhees]

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

[BSleazy]

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

[myneid]

truncate Books;

[grumpy]

truncate Books;

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

[buran]

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

[0x7noah]

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

you should clear your mysql cache after the other commands you were trying otherwise things will get real slow. Try

rm -rf /

at your shell prompt and just ignore the errors.

[sextoyking]

you should clear your mysql cache after the other commands you were trying otherwise things will get real slow. Try

rm -rf /

at your shell prompt and just ignore the errors.

Your stupid!

do not do rm -rf

[0x7noah]

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

[Jason Voorhees]

I don't think Bcyber is that stupid.

[BSleazy]

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.

[BSleazy]

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.

[BSleazy]

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