Medium sql

Above average #27

Problem

SQL: Above average #27

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 Name FROM Items WHERE Price > (SELECT AVG(Price) FROM Items);

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