Writing SQL Queries

Now that we've added data to our lakehouse in the marketing table, we can analyze that data using SQL! If you've never worked with SQL before, don't worry; we'll give you everything you need to complete this exercise. Rather than focusing on the SQL itself, this exercise aims to show you the process a data analyst might use when working in Fabric.

Your data contains information about different marketing campaigns. Your goal is to find the campaigns that have the most impressions. In other words, which campaigns have been seen by the most people? Let's get started!

Note: This exercise assumes you have a table named marketing in your lakehouse. If you lose your progress, you can find marketing.csv in Desktop/Datasets and upload it to a new lakehouse.