Challenge: Find Specific Books for a Reader
A patron asks for books from the Science Fiction genre that were published after 2010. You want to ensure the list contains only books that meet both conditions.
Swipe to start coding
Write an SQL query to fetch the titles and authors of all the books where the genre
is "Science Fiction" and the publication_year
is greater than 2010
.
The books
table includes these columns: id
, title
, author
, genre
, and publication_year
.
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: Find Specific Books for a Reader
Swipe to show menu
A patron asks for books from the Science Fiction genre that were published after 2010. You want to ensure the list contains only books that meet both conditions.
Swipe to start coding
Write an SQL query to fetch the titles and authors of all the books where the genre
is "Science Fiction" and the publication_year
is greater than 2010
.
The books
table includes these columns: id
, title
, author
, genre
, and publication_year
.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 1.72single