Mastering the MAX() OVER (PARTITION BY ... ORDER BY ..) Clause: A Guide to Troubleshooting and Optimization Strategies