Although I have an ulterior motive to learn how to do recursive queries as well. As an aside, there's also a lot of commentary on queries and an attempt to describe the limitation of SQL; like this is ...

The rest, as they say, is history. SQL is now 50 years old. SQL was designed and then adopted around databases, and it has continued to grow and develop as a way to manage and interact with data.