Coding task · SQL and MySQL course · Module 5: Modifying data (DML)

Update by condition

WHERE can point to rows by a value other than id. Use a comparison operator.

Task

Write a command that in the ksiazki table sets dostepna to 0 for all books with cena greater than 100. Use a WHERE clause with the > operator.