Itzik provides two examples of CTEs with multiple recursive members: genealogy-related queries and the nested set model for representing graphs.
seen from China

seen from United States
seen from Kazakhstan

seen from United States

seen from Malaysia

seen from United States

seen from Australia
seen from United States
seen from United States

seen from United States
seen from United States

seen from Malaysia

seen from Singapore
seen from United States
seen from France
seen from Macao SAR China

seen from Türkiye

seen from Malaysia

seen from Malaysia
seen from Yemen
Itzik provides two examples of CTEs with multiple recursive members: genealogy-related queries and the nested set model for representing graphs.