analyticsproduction

Describe your business question in plain English. AI will generate an optimized BigQuery SQL with proper schema awareness and safety validation.

Text to GoogleSQL

Generated Query

Valid

1SELECT DATE_TRUNC(order_date, WEEK) AS week_start, acquisition_channel, SUM(revenue) AS weekly_revenue,2COUNT(*) AS order_count FROM `analytics.orders` WHERE order_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 83WEEK) AND order_date < CURRENT_DATE() AND status = 'completed' GROUP BY DATE_TRUNC(order_date, WEEK),4acquisition_channel ORDER BY week_start DESC, weekly_revenue DESC;5678910111213141516

Est. cost~$0.02~240 MB scanned~2.1s

BigQuery Standard SQL