I find it helpful to have a piece of sample code to start a new query, especially the complicated ones. Here is a very simple query demonstrating recursion and CTE (common table expressions)
I took the code directly from a Microsoft example, but simplified it greatly to better suit our main goal here - Rapid Application Development (RAD)