Coding task · SQL and MySQL course · Module 6: Aggregation and grouping
Frequent author countries
Show the countries from which at least 5 authors come. Group by country and filter out the small groups.
Task
Write a query that selects kraj and COUNT(*) from the autorzy table, groups by kraj, and keeps only the groups with an author count greater than or equal to 5 (HAVING COUNT(*) >= 5).