Which engineer makes the cut?

Question

Accepted Answer

Multiple CTEs are separated by commas after WITH. The second CTE 'top_eng' can reference the first CTE 'eng'. 'eng' filters to Engineering employees (Alice and Bob). 'top_eng' keeps only those with the max salary in 'eng' - MAX is 90000, which is Alice. This chaining of CTEs is how you build complex logic in readable steps.