CockroachDB: create table, insert data and query it

cockroach-sql-dml-query.sh

core@ip-10-0-7-99 ~ $ docker run -it cockroachdb/cockroach:beta-20160512 sql --host=10.0.7.99 --port=12504 --user=maxroach
# Welcome to the cockroach SQL interface.
# All statements must be terminated by a semicolon.
# To exit: CTRL + D.
maxroach@10.0.7.99:12504> SET DATABASE = bank;
maxroach@10.0.7.99:12504> CREATE TABLE accounts (id INT PRIMARY KEY, balance INT);
maxroach@10.0.7.99:12504> INSERT INTO accounts (id, balance) VALUES (1, 1000), (2, 250);
INSERT 2
maxroach@10.0.7.99:12504> INSERT INTO accounts (id, balance) VALUES (3, 10), (4, 670);
INSERT 2
maxroach@10.0.7.99:12504> SELECT id, balance FROM accounts;
+----+---------+
| id | balance |
+----+---------+
|  1 |    1000 |
|  2 |     250 |
|  3 |      10 |
|  4 |     670 |
+----+---------+
maxroach@10.0.7.99:12504> SELECT SUM(balance) FROM accounts;
+--------------+
| SUM(balance) |
+--------------+
|         1930 |
+--------------+
maxroach@10.0.7.99:12504> SELECT AVG(balance) FROM accounts;
+----------------------+
|     AVG(balance)     |
+----------------------+
| 482.5000000000000000 |
+----------------------+