Interview Guides
You are given a table of PNC campaign interactions from channels such as email, paid search, and display. Write a SQL query to calculate the conversion rate for each campaign using only this table. Treat a row as a conversion when converted = true, and define conversion rate as converted interactions divided by total interactions, multiplied by 100. Return each campaign with its total interactions, total conversions, and conversion rate rounded to 2 decimal places, ordered from highest conversion rate to lowest.
