A local bookstore reached out to Bindle asking how many crime books are in Bindle’s library? Turned out it’s the most popular section in a book store
There are 3 genres of books in Bindle’s database that could count as crime books: Detective, Thriller, and Horror. Let’s count how many books in total we have in these categories.
NOTE: Genre in the
books table is stored in the column
genre. Check out the Database info tab for more details or just query it
SELECT * FROM books