- Make sure you have a modern-ish version of Node.js installed.
- Type
npx https://gist.github.com/kfox/1280c2f0ee8324067dba15300e0f2fd3
- Connect to it from a client, e.g.
netcat
or similar:nc localhost 9000
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