SELECT
"country",
COUNT(*) AS movies
FROM
@kaggle.thedevastator_oscar_award_nominees_and_winners_1929_2020_movie.movie_data
GROUP BY "country"
HAVING "movies" > 1
ORDER BY "movies" ASC
SELECT
"country",
COUNT(*) AS movies
FROM
@kaggle.thedevastator_oscar_award_nominees_and_winners_1929_2020_movie.movie_data
GROUP BY "country"
HAVING "movies" > 1
ORDER BY "movies" ASC
Anyone who has the link will be able to view this.