SELECT *
FROM orders
WHERE order_date >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH);