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: <code data-prestyled="true" class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono">Employee</code>
Final Columns:
<ul>
<li><code data-prestyled="true" class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono">&quot;City&quot;</code></li>
<li><code data-prestyled="true" class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono">&quot;EmployeeCount&quot;</code></li>
</ul>
Order By: Order the results by <code data-prestyled="true" class="rounded dark:bg-gray-800 dark:text-white text-black bg-gray-100 px-[0.25rem] py-[0.1rem] text-sm font-normal font-mono">&quot;City&quot;</code>.
Important: Make sure to name the columns exactly as specified, and follow the ordering criteria.

Conditional Aggregation