Most Ordered Product by Country

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

Join transactions to products on product_id. Per product_name, count rows in transactions. Return the product_name(s) tied for the highest count AND that count. Include ties. Sort alphabetically by product_name.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.