Given a table of user ad impressions and another of ad clicks, write a query to calculate the click-through rate (CTR) per country, filtering out countries with fewer than 10,000 impressions.
Use the provided impression and click count columns. CTR should be expressed as a percentage.
country, total_impressions, total_clicks, and ctr_percentage.country ascending.| Column | Type | Description |
|---|---|---|
| impression_idPK | INT | Unique identifier for an impression batch |
| country | VARCHAR(100) | Country associated with the impressions |
| impression_count | INT | Number of impressions represented by the row |
| Column | Type | Description |
|---|---|---|
| click_idPK | INT | Unique identifier for a click record |
| impression_id | INT | Logical reference to the related impression record |
| click_count | INT | Number of clicks represented by the row |