For the department that controls more projects than any othe

For the department that controls more projects than any other department, retrieve its department number.

Solution

without LIMIT 1 ,the query will result the departments with the count of number of projects in descending order. With LIMIT 1 it will display the first row with highest count of number of projects. nulls last will display null values at the end.