Welcome to the Treehouse Community
Looking to learn something new?
Tetiana lukerievas5,641 Points
Is the test outcome correct?
The tests wants me to use
COUNT(*), which will count empty categories. But in the task I need "Count all the books in each genre.". No genre is also a gener?
In the library database there's a books table. There are
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.
SELECT genre, COUNT(genre) AS genre_count FROM books GROUP BY genre;
ivana kantnerova14,218 Points
SELECT genre, COUNT(*) AS genre_count FROM books GROUP BY genre;
this select first made the groups of genres and after that counts books in the each genre that's mean the (*) is correctly