Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Philip Rurka
Philip Rurka
8,633 Points

A question with SQL involving one of the code challenges.

Hello. The question I am faced with is this:

In the library database there's a books table. There are id, title, author, genre and first_published columns. Count all the books in each genre. Include the genre column first and the genre_count as the second column of information.

My answer is this :

SELECT genre, COUNT(genre) AS genre_count FROM books GROUP BY genre;

I am getting an error saying "Your query didn't perform the correct count." I can't figure out what is wrong.

Can you link the the challenge?

3 Answers

Your answer should be counting the number of rows returned for each genre. Your query should read:

SELECT GENRE, COUNT(*) AS genre_count FROM BOOKS GROUP BY GENRE;

Select genre, count(genre) as [genre_count] From books Group by genre;

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 90,705 Points
SELECT COUNT(genre) AS genre_count FROM books GROUP BY genre;

Try removing the genre column, since you're retrieving the column via your COUNT() function. :-)