See the following to learn about this important feature of modern SQL:
https://learnsql.com/blog/what-is-common-table-expression/