%defaultDatasource jdbc:h2:mem:db

DROP TABLE IF EXISTS cities;
CREATE TABLE cities(
    zip_code varchar(5),
    latitude float,
    longitude float,
    city varchar(100),
    state varchar(2),
    county varchar(100),
    PRIMARY KEY (zip_code),
) AS SELECT
    zip_code,
    latitude,
    longitude,
    city,
    state,
    county
FROM CSVREAD('../resources/data/UScity.csv')

SELECT * FROM cities WHERE state = 'NY'

SELECT * INTO ${citiesTable} FROM cities WHERE longitude BETWEEN -80 and -79;

%%javascript
var tableStart = "<table border>"
var tableTemplate = (zip, lat, long, city, state) => `<tr><td>${city}</td><td>${state}</td></tr>`
var tableFinish = "</table>"
beakerx.displayHTML(this, tableStart +
                          beakerx.citiesTable.values.reduce((tmp, item) => tmp + tableTemplate(...item), "") +
                          tableFinish)

s

SELECT * FROM cities WHE

INSERT INTO cities (zip_code, city, state) VAL