Solution to Exercise 3

Solution to exercise 3.

We'll cover the following...

Solution

Press + to interact
SELECT PROJECT, COUNT(Emp_Id) AS Emp_Count
FROM SALARY
GROUP BY PROJECT
ORDER BY Emp_Count DESC;

Again, the solution will work without using the alias for COUNT(Emp_Id) ...