Skip to content

Instantly share code, notes, and snippets.

View mirzalazuardi's full-sized avatar
🙃

Mirzalazuardi Hermawan mirzalazuardi

🙃
View GitHub Profile
-- Workers
-- The following data definition defines an organization's employee hierarchy. An employee is a manager if any other employee has their managerId set to the first employees id. An employee who is a manager may or may not also have a manager.
-- TABLE employees
-- id INTEGER NOT NULL PRIMARY KEY
-- managerId INTEGER REFERENCES employees(id)
-- name VARCHAR(30) NOT NULL
-- Write a query that selects the names of employees who are not managers.
SELECT *
FROM employees
WHERE id IN (SELECT id FROM employees WHERE managerId IS NULL)
### Keybase proof
I hereby claim:
* I am mirzalazuardi on github.
* I am mirzalazuardi (https://keybase.io/mirzalazuardi) on keybase.
* I have a public key ASCzDoTqBV31bYSm2slkGSLd6XZFA5irVOtCS4xaihKFngo
To claim this, I am signing this object:
@mirzalazuardi
mirzalazuardi / nginx.conf
Created December 30, 2017 12:27 — forked from terrywang/nginx.conf
nginx config file template for Debian and Ubuntu
# User and group used by worker processes
user www-data;
# Ideally # of worker processes = # of CPUs or cores
# Set to auto to autodetect
# max_clients = worker_processes * worker_connections
worker_processes auto;
pid /run/nginx.pid;
@mirzalazuardi
mirzalazuardi / .htaccess
Last active August 29, 2015 14:20 — forked from steffenr/.htaccess
# KILL THEM ETAGS
# http://www.askapache.com/htaccess/apache-speed-etags.html
FileETag none
# set expires header
<FilesMatch "\.(ico|jpg|jpeg|png|gif|js|css|swf|woff|eot|svg|ttf)$">
Header set Expires "Tue, 16 Jun 2020 20:00:00 GMT"
</FilesMatch>
# turn on gzip compression