Challenge: Mark Archived Books As Unavailable
As you were going through the book records, you noticed that several older books are still marked as available, even though they are reserved for archival purposes. You need to update the is_available
column to FALSE
for all books that are:
- Published before the year
1950
; - Belong to the
Historical Fiction
orClassic
genres.
Swipe to start coding
Your task is to write an UPDATE
statement to modify multiple rows in the books table based on these conditions.
Note
The rows that are to be modified must match both of the conditions.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Summarize this chapter
Explain the code in file
Explain why file doesn't solve the task
Awesome!
Completion rate improved to 1.72
Challenge: Mark Archived Books As Unavailable
Swipe to show menu
As you were going through the book records, you noticed that several older books are still marked as available, even though they are reserved for archival purposes. You need to update the is_available
column to FALSE
for all books that are:
- Published before the year
1950
; - Belong to the
Historical Fiction
orClassic
genres.
Swipe to start coding
Your task is to write an UPDATE
statement to modify multiple rows in the books table based on these conditions.
Note
The rows that are to be modified must match both of the conditions.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 1.72single