Replace GROUP BY with correlated subqueries for snapshot data.
MySQL strict mode requires all SELECT columns in GROUP BY.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>