Most Ordered Product by Country

A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain

SQL

Difficulty

medium

Seniority

L4

Interview Prompt

The merchandising team wants the bestseller. Find every product that ties for the highest number of recorded transactions, and show the product name and that count. Include all products tied at the top, sorted alphabetically by product name.

Summary

Popular products in specific markets.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write your sql solution with real code execution
4. Get instant feedback and a hire/no-hire decision