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.