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

Delete unavailable books

DELETE with WHERE can cover many rows at once - all those that satisfy the condition.

Task

Write a command that removes from the ksiazki table all books marked as unavailable (dostepna = 0). Use a WHERE clause.