DB Quacks SQL Tutorial · Chapter 4
CASE Closed: The Duck Detective Story
Detective duck approaches with a magnifying glass. Elementary! I need to categorize ducks as Young (2 or under), Adult (3-4), or Senior (5+) for demographic analysis. Help solve this classification mystery!
Your task
Show each duck's name with their age category (Young/Adult/Senior) based on their age from the 'data/ducks.csv' table. You will be creating conditional logic to categorize ducks into age groups.