Writing SQL Queries

Now that we’ve added data to our marketing table in the lakehouse, let’s analyze it using SQL!

Don’t worry if you’re new to SQL, we’ll guide you through it. The focus here isn’t the code itself, but the workflow a data analyst might follow in Fabric.

Your task is to find the marketing campaigns with the most impressions!

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.