Skip to content

Instantly share code, notes, and snippets.

View wgopar's full-sized avatar

will wgopar

  • San Francisco Bay Area
View GitHub Profile
@wgopar
wgopar / MySQL_practice_problems.md
Last active June 22, 2024 14:49
MySQL Employees Sample Database exercise problems + solutions.

MySQL practice problems using the Employees Sample Database along with my solutions. See here for database installation details.

Problem 1

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