array_agg(DISTINCT student_telephone.phone_number) AS phones, ...
SELECT id, jsondata::city city , table_col AS sports_clubs FROM json_tab JOIN TABLE(JSON_TO_ARRAY(jsondata::sports_teams))), t1 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback