Use HAVING to filter groups with sum of salaries exceeding 100000.
Toolliyo Coach
Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.
Editor is open — no login wall to practice.
| Test | Status | Details |
|---|
Ready — edit the code above and click Run or Submit.
-- Sample schema
CREATE TABLE Employees (Id INT, Name TEXT, DeptId INT, Salary INT);
CREATE TABLE Departments (Id INT, Name TEXT);
INSERT INTO Employees VALUES (1,'Ali',1,90000),(2,'Sara',2,120000),(3,'Raj',1,75000);
INSERT INTO Departments VALUES (1,'Engineering'),(2,'Sales');
SELECT d.Name, SUM(e.Salary) AS Total
FROM Employees e
JOIN Departments d ON e.DeptId = d.Id
GROUP BY d.Name
HAVING SUM(e.Salary) > 100000;Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.
HAVING filters after aggregation; WHERE filters rows before.
Sign in to save and review your submission history. You can still Run code on the Editor tab as a guest.
Sign in