MySQL practice problems using the Employees Sample Database along with my solutions. See here for database installation details.
Find the number of Male (M) and Female (F) employees in the database and order the counts in descending order.
SELECT gender, COUNT(*) AS total_count
FROM employees
GROUP BY gender