Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- deviceid year month value
- 432 2019 3 2571
- 432 2019 2 90
- 432 2019 1 314
- 432 2018 12 0
- 432 2018 11 100
- 437 2019 2 0
- 437 2019 1 1
- 437 2018 12 0
- 437 2018 11 3
- 437 2018 10 2
- 437 2018 9 0
- 437 2018 8 2
- deviceId Average
- 432 991.7
- 437 0.3
- select deviceId, avg(value) from Table group by deviceid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement