Find top countries by population per continent

### Table `world_population` - `continent` VARCHAR - `country` VARCHAR - `population` BIGINT Assume each row is a country’s latest population and `(continent, country)` is unique. ### Tasks 1. Return the **most populous country in each continent**. - Output columns: `continent`, `country`, `population`. 2. Follow-up: Return the **top 2 most populous countries in each continent**. - Output columns: `continent`, `country`, `population`, plus a `rank_in_continent` (1 = largest). 3. Follow-up: For each continent’s **top 2** countries, compute what **percentage of the continent’s total population** each country represents. - Output columns: `continent`, `country`, `population`, `continent_population`, `population_share_pct`. - `population_share_pct = 100 * population / continent_population` (round to 2 decimals). ### Notes - If there are ties in population, break ties by `country` ascending to make results deterministic.