Why you should use SQL CTEs
Too Long; Didn't Read
CTEs (common table expressions) are persisted temporary data sets, that allow you to store a single query to go back to later in your script. They’re underrated compared to the subquery, that seems to be what most analysts around me use. Here’s why I prefer to use CTEs when building SQL queries.