Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Posted by Mr Matthew Cooke
Mr Matthew Cooke
2,161 Points

My query for sci fi librarybook count isn't working and I don't know why?

SELECT COUNT(genre = "Science Fiction") AS scifi_book_count FROM books;

this is what I have tried, to check how many books with the genre "science fiction" exist and then allis as scifi_book_count

but it says my query didn't perform the right thing..?It delivers the number 19

1 Answer

jcorum
jcorum
71,830 Points

Without a link to the challenge it's difficult to know what you are supposed to do. But there is a mistake in your SQL:

SELECT COUNT(genre = "Science Fiction") AS scifi_book_count FROM books;

You are trying to put a WHERE clause inside the COUNT, and that won't work.

First, you use COUNT, then you limit the rows/records that are included in the count with a WHERE clause:

SELECT COUNT(*) AS scifi_book_count FROM books WHERE genre = 'Science Fiction';

Hope this helps.