Skip to content

Instantly share code, notes, and snippets.

[{"state":"GA","email":null,"ip_address":"114.63.187.46","client_browser":"mozilla","feedback":null,"session":{"pages_visited":["links","about","support"],"date":"07/28/2017","time":"17:10","errors":[400,404]}},
{"state":"LA","email":"acahen1@aol.com","ip_address":"23.2.7.157","client_browser":"ie","feedback":"Praesent lectus. Vestibulum quam sapien, varius ut, blandit non, interdum in, ante. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Duis faucibus accumsan odio. Curabitur convallis.","session":{"pages_visited":["product","all_products"],"date":"07/06/2017","time":"7:42","errors":null}},
{"state":"RI","email":"dhumberstone2@inbox.com","ip_address":"55.211.198.15","client_browser":"chrome","feedback":"Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.","session":{"pages_visited":["about","links"],"date":"07/12/2017","time":"15:23","errors":null}},
{"state":"MA","email":null,"ip_address":"189.127.122.93","client_browser":"chrome","fe
SELECT
business.name,
business.full_address,
business.city,
business.state,
review.text,
review."date" AS "date",
review.user_id AS user_id,
review.stars AS stars,
review.text AS text
SELECT
business.name,
business.full_address,
business.city,
business.state,
review.text,
review."date" AS "date",
review.user_id AS user_id,
review.stars AS stars,
review.text AS text
SELECT
business.name,
business.full_address,
business.city,
business.state,
review.text,
review."date" AS "date",
review.user_id AS user_id,
review.stars AS stars,
review.text AS text
SELECT
business.name,
business.full_address,
business.city,
business.state,
review.text,
review."date" AS "date",
review.user_id AS user_id,
review.stars AS stars,
review.text AS text
SELECT * FROM health_data.health_study_data
SELECT * FROM health_data.health_study_data
SELECT street, COUNT(*)
FROM health_data.health_study_data
GROUP BY street
curl --output dremio-community-1.2.1.rpm https://download.dremio.com/community-server/1.2.1-201710030121530889-8e49316/dremio-community-1.2.1-201710030121530889_8e49316_1.noarch.rpm
curl -o oracle_distrib.zip http://download.oracle.com/otn/linux/oracle12c/122010/linuxx64_12201_database.zip?AuthParam=1509038589_c846c27089a37b95d0cd65a9dc741c40