How to use the SQL DELETE clause

Deletion is a fundamental operation when working with relational databases. It is used when one or more rows are to be removed from a table. The WHERE clause always accompanies the DELETE clause. So, let's say we have a table of user posts. To delet...