Delete

Let's look at some posts of another user:

Input

It looks like this user has a duplicate post. It should be possible to delete a post you don't like. DELETE command uses the same mechanism as SELECT to find the items to be deleted, also, just like INSERT and UPDATE, a DELETE command can be wrapped in "(...)" and used an an expression. Let's pretend that Cameron wants to delete the last text post:

Input

Let's make sure that we've deleted the right post:

Input