Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT date_trunc('day', TIME) AS DAY, avg(VALUE)
- FROM raw
- JOIN times USING (file_id, ROW)
- WHERE series_id=2665
- GROUP BY date_trunc('day', TIME)
- ORDER BY date_trunc('day', TIME)+INTERVAL '0 day'
Add Comment
Please, Sign In to add comment