Free SQL Queries Cheat Sheet — Joins, Aggregations & Window Functions Online

chmod 755 filename.sh

find / -type f -size +100M -exec ls -lh {} \;

tar -czvf backup-archive.tar.gz /var/www/html

fuser -k 3000/tcp || npx kill-port 3000

htop || top -o %CPU

git rebase -i HEAD~3

git reset --soft HEAD~1

git stash push -m 'WIP: auth integration refactor'

git cherry-pick a1b2c3d4

git branch -D feature/login && git push origin --delete feature/login

docker run -d -p 8080:80 --name my-web-app nginx:alpine

docker system prune -a --volumes -f

docker logs -f --tail 100 <container-id>

docker exec -it <container-id> /bin/sh

HTTP/1.1 201 Created
Location: /api/v1/orders/108

HTTP/1.1 301 Moved Permanently
Location: https://example.com/new-url

HTTP/1.1 401 Unauthorized (Missing/Expired JWT)
HTTP/1.1 403 Forbidden (Valid JWT, but not Admin)

502: Reverse proxy (Nginx) got invalid response from upstream (Node/Python).
504: Upstream did not respond before proxy timeout.

SELECT employee_id, department, salary, DENSE_RANK() OVER (PARTITION BY department ORDER BY salary DESC) as rank FROM employees;

SELECT email, COUNT(*) FROM users GROUP BY email HAVING COUNT(*) > 1;

WITH active_subs AS (
  SELECT user_id, plan_id, created_at FROM subscriptions WHERE status = 'active'
)
SELECT u.email, s.plan_id FROM users u JOIN active_subs s ON u.id = s.user_id;