DELETE FROM table_name [ [ AS ] alias ]
[ WHERE booleanExpression ]

DELETE FROM lineitem WHERE shipmode = 'AIR';

DELETE FROM lineitem
WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');

DELETE FROM orders;