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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

Find products with at least 1 purchase and a unit-weighted average price (total amount divided by quantity) of at least $100. Pull the product name from the products table. Return the product ID, product name, and average unit price.

Summary

Budget-friendly and high-performing.

Practice This Problem

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