Advanced SQL topics As your SQL skills progress, challenge ChatGPT with more advanced topics. Ask about subqueries, window functions, common table expressions and transactions.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.