📄️ Simple selects
Common table expressions (CTE) are a great way to modularize complex queries.
📄️ Inserts, updates and deletions
Some databases like postgres also allow you to run other queries than selects
CTE
Short and simple examples of how to use common table expressions (CTE) in queries.