Average salary by department

Medium 30 pts New · no attempts yet sql

Topics

Toolliyo edge

Calculate average salary per department.

Static hints

GROUP BY department, use AVG(Salary)

Toolliyo Coach

Stuck? Get a nudge — not the answer

Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.

Your solution

Editor is open — no login wall to practice.

Ready — edit the code above and click Run or Submit.

Official solution

-- 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, AVG(e.Salary) AS AvgSalary
FROM Employees e
JOIN Departments d ON e.DeptId = d.Id
GROUP BY d.Name;

Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.

Explanation

GROUP BY with aggregate functions—SQL interview staple.

Next All problems

Average salary by department

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion