Both DELETE statements delete records from multiple tables i.e., table_1 , table_2 ,… specified after the DELETE keyword.
The first DELETE statement uses the FROM clause while the second one use the USING clause.
The WHERE clause is used to determine which record to be deleted.
Both statements return the number of rows deleted from the multiple tables.