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

nicolaslemaire
nicolaslemaire
12,806 Points
Posted by nicolaslemaire
nicolaslemaire
12,806 Points

Problem with task 2 of 2 (reporting with SQL)

Hi guys, here comes the link: https://teamtreehouse.com/library/reporting-with-sql/aggregate-and-numeric-functions/counting-groups

I only need task2 actually, task1 is OK. Here's my answer, looks correct to me but doesn't want to pass me, any help on that? thanks very much indeed: Question for those who cannot reach the link:

"In the library database there's a books table. There are id, title, author, genre and first_published columns. Write a query to count all the unique genres in the books table. Alias it as total_genres."

SELECT COUNT(DISTINCT genre) AS "total_genres" FROM books GROUP BY genre;

Bye!

1 Answer

Joel Bardsley
Joel Bardsley
31,249 Points
Joel Bardsley
Joel Bardsley
31,249 Points

As you're using the DISTINCT statement, all the values will be different so there's no need to use the GROUP BY on your results. Remove that and the challenge should pass.

nicolaslemaire
nicolaslemaire
12,806 Points
nicolaslemaire
nicolaslemaire
12,806 Points

Thanks much Joel, worked wonders :) take care!