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.
| Column | Type | Description |
|---|---|---|
| campaign_idPK | INT | Unique row identifier |
| campaign_name | VARCHAR(100) | Name of the marketing campaign |
| channel | VARCHAR(50) | Marketing channel used |
| send_date | DATE | Date the campaign was sent |
| emails_sent | INT | Number of emails sent |
| clicks | INT | Number of clicks generated |
| conversion_rate | DECIMAL(5,2) | Conversion rate percentage for the send |
| delivery_status | VARCHAR(20) | Status of the send record |