For those interested, when talking about the WITH clause, I believe the author is describing Common Table Expressions (CTE) which are very useful to understand and can be recursive. For anyone who cares about formatting their SQL, I use and recommend this online formatting site all the time:
https://poorsql.com/ I believe there is an add-on for sql server management studios too.

Written by

Software Product Analyst in Data Science. pythondashboards.com Top writer in Business www.linkedin.com/in/erickleppen01/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store