Analyst
Lead Analyst
Project
Meridian Retail Co. · SQL · beginner
The brief
The auditors are asking how much of our data still ties back to the old 2019 system. One piece of that answer is yours: the customers table has a legacy_crm_id column, filled only for customers that came from the old CRM. Count how many customers have a legacy id, and how many do not. Two numbers, clearly labelled.
Independent grading
95/100
Achieved 5 Nov 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more