DB Quacks SQL Tutorial · Chapter 4
DuckCon 2024: Executive Dashboard Madness
CEO duck in a business suit flaps over frantically. Emergency! DuckCon starts tomorrow and the board needs executive data - species visit counts, only species with 3+ visits, sorted by count!
Your task
Show each species and their total visit count, only for species with more than 3 visits, sorted by count. You will be joining the ducks table with 'data/pond_visits.csv', then grouping and filtering the results.