Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Lead Analyst

Project

Count the Legacy Customers

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