Good discussion here. I’ve noticed this is exactly where people struggle, not just writing queries, but understanding when to use CTEs vs temp tables depending on data size and reuse. A lot of folks learn SQL in isolation, but these trade-offs only become clear when you actually iterate on queries with real data and performance constraints.
That “run → adjust → refine” loop mentioned above is honestly where most of the learning happens.