DAAS Labs interview question

Describe how recursive queries work in SQL. Provide an example scenario where a recursive query would be beneficial.