Welcome to the Treehouse Community
Looking to learn something new?
In the library database, how many books are with the genre of "Science Fiction"? Alias the result as scifi_book_count. The books table has the columns id, title, author, genre and first_published.
SELECT COUNT(genre = "Science Fiction") AS "scifi_book_count" FROM books;
Brendan WhitingFront End Web Development Techdegree Graduate 84,696 Points
We can't put the "= Science Fiction" inside the count function, it has to go in a WHERE clause.
SELECT COUNT(genre) as scifi_book_count FROM books WHERE genre = "Science Fiction";