Challenge: Help a Reader Find Their Favorite Genre
You are doing your job as a librarian when a reader approaches you saying they're in the mood for books from the Fantasy genre. They ask you to quickly find all the books in that category.
Swipe to start coding
Write an SQL query using the WHERE
clause to find the titles of all the books where the genre is "Fantasy"
.
The books
table includes the columns: id
, title
, author
, genre
, publication_year
, and price
.
Note
Strings in SQL are case-sensitive. Therefore
'fantasy'
is not the same as'Fantasy'
.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 1.72
Challenge: Help a Reader Find Their Favorite Genre
Swipe to show menu
You are doing your job as a librarian when a reader approaches you saying they're in the mood for books from the Fantasy genre. They ask you to quickly find all the books in that category.
Swipe to start coding
Write an SQL query using the WHERE
clause to find the titles of all the books where the genre is "Fantasy"
.
The books
table includes the columns: id
, title
, author
, genre
, publication_year
, and price
.
Note
Strings in SQL are case-sensitive. Therefore
'fantasy'
is not the same as'Fantasy'
.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 1.72single