START TRANSACTION;

-- count the number of orders
SELECT COUNT(*) FROM orders;

-- DELETE all the orders
DELETE FROM orders;