Top Shelf

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The procurement team negotiates vendor contracts based on price ceilings in each product category. For every category, they need the highest price and the name of the product at that price point. If a product has no price on record, skip it. Show only the top three most expensive categories by their ceiling price.

Summary

Buyers need to know ceiling prices before negotiating with vendors.

Practice This Problem

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