Welcome to the Treehouse Community
Looking to learn something new?
Can help me on this SQL error? Thanks.
In the library database, how many books are with the genre of "Science Fiction"? Alias the result as scifi_book_count.
Without a link to the challenge, I can only make guesses, but it should be something like this, assuming the table in the database is books:
SELECT COUNT(*) AS scifi_book_count FROM books WHERE genre = "Science Fiction";