Zadanie: Show the list of countries with more than 3 actors. Show the name of country and count of actors.
actors
aID firstname lastname year_of_birth income earned country
1 Woody Hopkins 1975 1995 100000 Australia
2 Tibor Tandy 1965 2001 2458771 France
3 John Torn 1994 2015 7778852 USA
4 Natalie Hunt 1957 2002 15000001 USA
5 Juan Stock 1978 1999 154557 Australia
6 Henry Nolte 1968 2005 1154775 France
7 Woody Seller 1945 1984 8425771 Australia
8 Hypolia Genders 1995 2002 333345 Australia
Moje rozwiazanie :
SELECT country, COUNT(country) AS new
From actors
WHERE new >3
Group by country;