as a reminder, recursion has been introduced intosequal as part of the with statement where we can set up relations that are defined by queries that themselves refer to the relation being defined, and finally we have a query that can involve the recursively defined relations as well as other relations or other tables in the database.