Reading the generated SQL
You asked the "Bakehouse Sales" Genie space: "Show me total revenue by franchise city last quarter." Genie returned a table with cities and revenue figures. Curious about how Genie arrived at these results, you clicked Show code and saw the SQL it generated - a SELECT with a JOIN between sales_transactions and sales_franchises, a WHERE clause for the date range, and a GROUP BY on the city column.
What is the main benefit of reviewing the SQL that Genie generates?
Questo esercizio fa parte del corso
Introduction to Databricks Genie
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio