SQL Delete Syntax
Simple Delete:
DELETE FROM TableName WHERE some_column=some_value
Delete NULL Values:
DELETE FROM TableName WHERE some_column IS NULL
Delete NULL and Empty String Values:
DELETE FROM TableName WHERE COALESCE(some_column, '') = ''
Delete with values from separate table:
DELETE FROM TableName WHERE some_column IN (SELECT TableId FROM TableName2 WHERE TableName2ColumnId = value)