Skip to content

Instantly share code, notes, and snippets.

@mustafaakin

mustafaakin/query.sql

Last active July 2, 2017 09:00
Show Gist options
  • Save mustafaakin/87ee99ceb1b1a526b2a49c47e87c428e to your computer and use it in GitHub Desktop.
Save mustafaakin/87ee99ceb1b1a526b2a49c47e87c428e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
SELECT
room,
TUMBLE_END(rowtime, INTERVAL ‘10’ SECOND),
AVG(temperature) AS avgTemp
FROM sensors
GROUP BY
TUMBLE(rowtime, INTERVAL ‘10’ SECOND),
room
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment