One question that usually stumps people who write that they know SQL on their resume but really don't is asking them how to use window functions. A very simple window function is looking at a 30 day moving average. ChatGPT provided the correct answer: