# Most Ordered Product by Country

> Popular products in specific markets.

Canonical URL: <https://datadriven.io/problems/most_ordered_product_by_country>

Domain: SQL · Difficulty: medium · Seniority: L4

## Problem

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.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/most_ordered_product_by_country)
- [SQL Interview Questions](https://datadriven.io/sql-interview-questions)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.