Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Which of the following SQL statements correctly finds the average salary per department_id?
SELECT Department_id, AVG(Salary) FROM Employees GROUP BY Department_id;
SELECT Department_id, Salary FROM Employees GROUP BY Department_id;
SELECT Department_id, AVG(Salary) FROM Employees;
SELECT AVG(Salary) GROUP BY Department_id FROM Employees;
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!