Interview Guides
You are given a table of customer-level offer outcomes from PNC marketing campaigns. Write a SQL query to calculate the percentage of customers who converted after receiving an offer for each campaign_name. Treat a customer as converted only when converted = TRUE. Return the campaign name, the total number of customers who received the offer, the number who converted, and the conversion percentage rounded to 2 decimal places. Sort the results by conversion percentage descending, then by campaign name.
