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

Delete by two conditions

Combine two conditions with the AND clause to remove exactly the chosen rows.

Task

Write a command that removes from the ksiazki table books that are unavailable (dostepna = 0) AND come from autor_id = 4. Use WHERE with AND.