Subquery vs CTE in SQL: Same Logic, One You Can Check

By the end of this page you can write a query that uses the answer to another query, recognise the four places one can go, spot the correlated kind that runs once per row, avoid the NOT IN that silent