01Why can you NOT use a window function (e.g., RANK() OVER (...)) in a WHERE clause?
02What is the effect of using an ORDER BY clause inside an OVER() partition without a specific frame?
03What is the difference between RANK() and DENSE_RANK() when handling a tie between two rows with the same value?
04Which analytic function is most efficient for calculating 'Month-over-Month' growth by accessing the value of a previous row without a self-join?
05What is the primary difference between the WHERE clause and the HAVING clause in an SQL statement?