docker run --name postgres -p 5432 -e POSTGRES_PASSWORD=secret postgres
$ docker exec -ti postgres psql -h localhost -U postgres
create database tpch;
(cd scripts; pip3 install -r requirements.txt; python3 setup-postgres.py)
$ docker exec -ti postgres psql -h localhost -U postgres
\c tpch;
select * from nation;
SELECT n."N_NAME", SUM(s."S_ACCTBAL") AS total_acctbal
FROM nation n
JOIN supplier s ON n."N_NATIONKEY" = s."S_NATIONKEY"
GROUP BY n."N_NAME"
ORDER BY n."N_NAME";