kfox

TCP echo server for Node.js

Usage

1. Make sure you have a modern-ish version of Node.js installed.
2. Type npx https://gist.github.com/kfox/1280c2f0ee8324067dba15300e0f2fd3
3. Connect to it from a client, e.g. netcat or similar: nc localhost 9000

wgopar

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