unnest(string_to_array(concat_ws(';',used_nm),';')) as tab_interest
oracle 行转列
listagg(city,',') within GROUP (order by city) over (partition by nation) rank