Challenge: Correct Book's Data
The library staff discovered an error in the database for the books table. A recently added book has incorrect information, and you need to update it.
Specifically:
The book with book_id = 5 currently has the title 'The Greatest Gatsby'. However, the title was entered incorrectly, and it should be updated to 'The Great Gatsby'.
Additionally, this book's is_available status is incorrect and should be set to FALSE because it has been lent out.
Swipe to start coding
Your task is to write an UPDATE statement to correct this information in the books table.
The syntax of the UPDATE statement is:
UPDATE table_name
SET column1 = value1,
column2 = value2,
...
WHERE condition;
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.72Challenge: Correct Book's Data
Swipe to show menu
The library staff discovered an error in the database for the books table. A recently added book has incorrect information, and you need to update it.
Specifically:
The book with book_id = 5 currently has the title 'The Greatest Gatsby'. However, the title was entered incorrectly, and it should be updated to 'The Great Gatsby'.
Additionally, this book's is_available status is incorrect and should be set to FALSE because it has been lent out.
Swipe to start coding
Your task is to write an UPDATE statement to correct this information in the books table.
The syntax of the UPDATE statement is:
UPDATE table_name
SET column1 = value1,
column2 = value2,
...
WHERE condition;
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Awesome!
Completion rate improved to 1.72single
