Level 2 - JuniorOptimization Questions
Optimization-Lite: Date Filter and Column Hygiene
Choose the better query for performance and maintainability, then provide the final SQL. Query A: SELECT * FROM orders WHERE DATE(order_date) >= '2026-03-01' AND customer_id = 42; Query B: SELECT id, order_date, total_amount FROM orders WHERE order_date >= '2026-03-01' AND customer_id = 42;