DB Quacks SQL Tutorial · Chapter 2
The Great Duck Statistics Quest
Dr. Stork, the village statistician, waddles over with a clipboard. I need to prepare the annual health report! How many ducks do we have? Whats the average age? Whos the youngest and oldest? I need these basic statistics for my report!
Your task
Calculate basic statistics about all ducks from the ducks table: total count, average age, minimum age, and maximum age. You will be using aggregate functions to summarize the data.