Level 10 - MasterOptimization Questionsm3 governance security cost control
Optimization: Cost-Efficient Long-Range Report Query
Choose the better query for monthly cost report and provide final SQL. Query A: SELECT DATE(created_at) AS d, SUM(cost_usd) FROM usage_events GROUP BY DATE(created_at); Query B: SELECT date_bucket, SUM(cost_usd) FROM usage_daily WHERE date_bucket >= DATE '2026-01-01' AND date_bucket < DATE '2026-02-01' GROUP BY date_bucket;
Schema Context
usage_events(event_id, created_at, cost_usd), usage_daily(date_bucket, cost_usd)