Contents

• Common table expressions
• CTEs in a nutshell
• Recursive CTEs
• Our challenge for today
• Our schema
• Our data
• A non-hierarchical query
• A hierarchical query
• A first attempt at sorting
• A better approach
• The End