with temp as(
select '中國' country ,'北京' city from dual 
union all
select '中國' country ,'深圳' city from dual 
union all
select '中國' country ,'上海' city from dual 
)
select country,listagg(city,',') within GROUP (order by country) as brands
from temp
group by country