DB Quacks SQL Tutorial · Chapter 6
Inception: We Need to Go Deeper
Dream architect duck approaches in dark glasses. We must go deeper! Find ducks older than average age, but I dont know the average! Use a query inside another query - nested intelligence!
Your task
Find all ducks from the ducks table whose age is greater than the average age of all ducks. You will be using a subquery to calculate the average age first.