More Visual Query Features

Nice work writing your first visual query! Let's now dive a bit deeper into the power of the visual query editor. Let's say we want to find which customer_segment has the highest average Return on Investment (ROI). If we were writing SQL, we would have to use GROUP BY and AVG(). Let's take a look at how to write this query visually.

Note: this exercise assumes you have loaded a table named marketing in your lakehouse. If you lost your progress and don't have access to your lakehouse, you can find marketing.csv in Desktop/Datasets and upload it to a new lakehouse.