Help_for_class2021

I'm trying to get some information from GKG_PARTITIONED for my class and I'm struggeling this part that does not work.

CREATE OR REPLACE TABLE
`neon-fort-3111415.ipusonim.israel_media2`
SELECT;
persons,
COUNT(1) AS count_mentions,
COUNT(DISTINCT url) AS count_distinct_urls
FROM
`gdelt-bq.gdeltv2.gkg_partitioned`
GROUP BY
person
ORDER BY
count_mentions DESC
LIMIT
10;


I want the table will show me that number of times some people were mentiond and the URL's.

Continue reading...