Conditional Aggregation
Medium
1
85.7% Acceptance
Write a SQL query to count the number of employees in each city. However, you should only include cities that have more than one employee.
Table Used: Employee
Final Columns:
"City"
"EmployeeCount"
Order By: Order the results by "City"
.
Important: Make sure to name the columns exactly as specified, and follow the ordering criteria.