Interview Guides
You are asked to prepare a simple leadership summary of marketing campaign performance from a single table used for PNC campaign reporting. Write a SQL query that returns one row per campaign for delivered campaigns only, showing the campaign name, total emails sent, total clicks, and average conversion rate. Sort the results so the strongest-performing campaigns appear first by total clicks.
