MySQL: Fix Inflated Customer Count in Category Engagement Report
MySQL aggregation exercise focused on customer engagement reporting using COUNT and COUNT(DISTINCT) in grouped queries. Covers how different counting approaches affect aggregated results per category, how grouping interacts with customer-level data, and how to accurately compute unique customer metrics across transactional datasets. Includes comparison of alternative query outputs for analysis.
Comentarii