DB Quacks SQL Tutorial · Chapter 5
Duck Dynasty: The Recursive Family Saga
Dr. Stork returns with touching news! Families want reunion events at the festival! Grandpa Quackers (parent ID 1) has family scattered across generations but wants to reunite. We need to trace ALL his descendants through every generation for proper invitations!
Your task
Find all descendants of Grandpa Quackers (parent ID 1) through multiple generations using the 'data/duck_family.csv' file. You will be using recursive CTEs to traverse family relationships.