🚀 November has started! SQLtest.online stays free thanks to donations from people like you. Help us reach this month's goal early so the site keeps running without interruptions. Support now →
SQL code copied to buffer
Task 28:

Build a unified customer view across systems

A pipeline loads customer data from a CRM, billing system, and product database, but the same customer has different IDs in each system. How would you design the data model and matching logic so analytics teams can use one reliable customer view?

Write your answer in the field below and click the "Check answer" button.

Answers are checked by AI, so checking needs an account. New accounts get free AI credits.
The AI feedback on your answer will appear here.