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...