I have two CTE's:

with screen as

$($

SELECT

user$\_$pseudo$\_$id as user$\_$id$,$

geo.country as country,

event$\_$timestamp,

CASE

WHEN params$1.$value.string$\_$value $=$ 'Duas' or params$1.$value.string$\_$value $=$ 'DuasTopics' THEN 'Duas'

WHEN params$1.$value.string$\_$value $=$ 'Explore' or params$1.$value.string$\_$value $=$ 'Topic' THEN 'Explore by Topic'

ELSE params$1.$value.string$\_$value

END AS screen$\_$name,

FROM

$`$table$`$ AS base,

UNNEST$($event$\_$params$)$ AS params$1$

WHERE

event$\_$name $=$ 'screen$\_$view'

AND params$1.$key $=$ 'firebase$\_$screen'

AND event$\_$date between $\text{'}20231001\text{'}$ and $\text{'}20231231\text{'}$

$)$

$,$

remove AS $($

SELECT

distinct user$\_$pseudo$\_$id

FROM

$`$table$`$

where event$\_$name$=$'app$\_$remove'

AND event$\_$date between $\text{'}20231001\text{'}$ and $\text{'}20231231\text{'}$

$)$

I want to find out the top $10$ countries where screen$\_$name 'settings' was the last screen viewed before app removal, along with the $\%$ of associated users.

For example Malaysia has $70\%$ users who viewed 'settings' before removing the app.