Two Names, One Campaign
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L4
Interview Prompt
Our ad team labels campaigns in loud uppercase like FLASH_SALE_48H while the push-notification team writes lowercase slugs like flash_sale, and the two naming systems were never reconciled. Some ad and push campaigns are secretly the same effort under different names because they share a theme word. Pair every ad campaign with the push campaign it matches on that shared theme.
Summary
The ad team and the push team never agreed on naming. Find where they secretly meant the same thing.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision