Mysql question - GoFuckYourself.com

BSleazy · 11-01-2010, 02:11 PM

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 · 11-01-2010, 02:17 PM

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

Senior_Spank · 11-01-2010, 02:17 PM

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 · 11-01-2010, 02:17 PM

need to "GROUP BY" something

sarettah · 11-01-2010, 02:18 PM

Quote:

Originally Posted by BCyber

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 · 11-01-2010, 02:19 PM

Quote:

Originally Posted by georgeyw

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

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

georgeyw · 11-01-2010, 02:23 PM

Quote:

Originally Posted by sarettah

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

haha - I refreshed and saw your reply

Tempest · 11-01-2010, 02:24 PM

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 · 11-01-2010, 02:29 PM

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

Jason Voorhees · 11-01-2010, 02:30 PM

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

BSleazy · 11-01-2010, 02:40 PM

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

myneid · 11-01-2010, 03:04 PM

truncate Books;

grumpy · 11-01-2010, 03:09 PM

Quote:

Originally Posted by myneid

truncate Books;

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

buran · 11-01-2010, 03:35 PM

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

0x7noah · 11-01-2010, 03:43 PM

Quote:

Originally Posted by BCyber

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

Code:

rm -rf /

at your shell prompt and just ignore the errors.

sextoyking · 11-01-2010, 03:45 PM

Quote:

Originally Posted by 0x7noah

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

Code:

rm -rf /

at your shell prompt and just ignore the errors.

Your stupid!

do not do rm -rf

0x7noah · 11-01-2010, 03:48 PM

Quote:

Originally Posted by sextoyking

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 · 11-01-2010, 04:13 PM

I don't think Bcyber is that stupid.

BSleazy · 11-01-2010, 05:13 PM

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 · 12-05-2010, 06:34 PM

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 · 12-05-2010, 06:36 PM

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

11-01-2010, 02:11 PM	#1
BSleazy Confirmed User Industry Role: Join Date: Aug 2002 Location: USA Posts: 6,721	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) __________________ icq 156131086

11-01-2010, 02:17 PM	#4
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	need to "GROUP BY" something __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

11-01-2010, 02:40 PM	#11
BSleazy Confirmed User Industry Role: Join Date: Aug 2002 Location: USA Posts: 6,721	Dam that was a lot of replies fast...thanks __________________ icq 156131086

11-01-2010, 03:04 PM	#12
myneid Confirmed User Industry Role: Join Date: Jan 2003 Location: Los Angeles Posts: 736	truncate Books; __________________ Tanguy 0x7a69 inc. Programmer/President/CEO http://www.0x7a69.com A Leader in Programming since 1996 PHP, Ruby on Rails, MySQL, PCI DSS, and any Technical Consulting

11-01-2010, 03:35 PM	#14
buran Confirmed User Join Date: Mar 2002 Location: how'd I get here? Posts: 264	Ohshit, can I get GFY to do my CS101 homework now? Werd! __________________ [this signature intentionally left blank]

11-01-2010, 02:17 PM	#2
georgeyw 58008 53773 Industry Role: Join Date: Jul 2005 Location: Australia Posts: 9,864	Select type, avg(price) from book where paperback = 'y' group by type

11-01-2010, 02:17 PM	#3
Senior_Spank Registered User Join Date: Aug 2006 Posts: 63	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

11-01-2010, 02:24 PM	#8
Tempest Too lazy to set a custom title Industry Role: Join Date: May 2004 Location: West Coast, Canada. Posts: 10,217	ha ha ha.. was going to post the same answer as everyone else when there were no replies and then there were 6

11-01-2010, 02:29 PM	#9
Jason Voorhees So Fucking Banned Industry Role: Join Date: Jul 2010 Location: Camp Crystal Lake. Posts: 843	Select type, avg(price) from book where paperback = 'y' group by type

11-01-2010, 02:30 PM	#10
Jason Voorhees So Fucking Banned Industry Role: Join Date: Jul 2010 Location: Camp Crystal Lake. Posts: 843	Oh... Oh shit... Am I too late?

11-01-2010, 04:13 PM	#18
Jason Voorhees So Fucking Banned Industry Role: Join Date: Jul 2010 Location: Camp Crystal Lake. Posts: 843	I don't think Bcyber is that stupid.

11-01-2010, 05:13 PM	#19
BSleazy Confirmed User Industry Role: Join Date: Aug 2002 Location: USA Posts: 6,721	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. __________________ icq 156131086

12-05-2010, 06:34 PM	#20
BSleazy Confirmed User Industry Role: Join Date: Aug 2002 Location: USA Posts: 6,721	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. __________________ icq 156131086

12-05-2010, 06:36 PM	#21
BSleazy Confirmed User Industry Role: Join Date: Aug 2002 Location: USA Posts: 6,721	nevermind...soon as i posted that i came across it in my book. __________________ icq 156131086