# High Price Products > Everything above 100. Canonical URL: Domain: SQL · Difficulty: easy · Seniority: L3 ## Problem The procurement team is renegotiating supplier contracts and needs the full record for every product priced above 100. ## Worked solution and explanation ### Why this problem exists in real interviews Filtering products above a price threshold tests basic WHERE clause construction with numeric comparison. This is a warm-up that verifies fundamental SQL fluency. --- ### Break down the requirements #### Step 1: Apply the price filter `WHERE price > 100` selects products above the threshold. #### Step 2: Return all columns The prompt asks for the full record, so use `SELECT *`. --- ### The solution **Simple numeric filter** ```sql SELECT * FROM products WHERE price > 100 ORDER BY price DESC ``` > **Cost Analysis** > > An index on `price` enables a range scan. Highly selective if most products are below the threshold. > **Interviewers Watch For** > > This is a basic filter question. Speed and accuracy matter. > **Common Pitfall** > > `>=` vs. `>` matters at the boundary. Clarify with the interviewer. --- ## Common follow-up questions - How would you find the top 5 most expensive? _(Tests ORDER BY price DESC LIMIT 5.)_ - How would you filter by category as well? _(Tests compound WHERE with AND.)_ - How would you compute the average price of expensive products? _(Tests AVG with the WHERE filter.)_ ## Related - [All practice problems](https://datadriven.io/problems) - [Mock interview mode](https://datadriven.io/interview/high_price_products) - [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.