SQL Practice Logo

SQLPractice Online

Level 5 - SeniorOptimization Questions

Optimization: Count Strategy

Interviewer prompt: Need daily paid order count by date. Pick better query. Query A: SELECT DATE(order_ts), COUNT(*) FROM orders WHERE status = 'PAID' GROUP BY DATE(order_ts); Query B: SELECT CAST(order_ts AS DATE) AS d, COUNT(*) FROM orders WHERE status = 'PAID' GROUP BY CAST(order_ts AS DATE);