Hard sql

Filter category X #22

Problem

SQL: Filter category X #22

Hints

Write SELECT with WHERE/GROUP BY

Your practice code

Ready — edit the code above and click Run.

Solution

-- Sample tables
CREATE TABLE Items (Id INT, Name TEXT, Price INT, Category TEXT);
INSERT INTO Items VALUES (1,'A',100,'X'),(2,'B',200,'X'),(3,'C',150,'Y');
SELECT * FROM Items WHERE Category = 'X' AND Price >= 310;

Try solving on your own first, then reveal the official answer.

Explanation

SQL interview practice.

Toolliyo Assistant

Ask about tutorials, ebooks, training, pricing, mentor services, and support. I use public site content only—not admin or internal tools.

care@toolliyo.com