X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=gnuplot%2Fby_temp.sql;fp=gnuplot%2Fby_temp.sql;h=cd936e67cba7f19721f99dac6d7033ce04b53e7a;hb=c5ed1420f53f0b1782fb8846f9814cd1aa634d3b;hp=0000000000000000000000000000000000000000;hpb=39201baaf25cc06e1b24bfb579868ba9929a4bee;p=zc

diff --git a/gnuplot/by_temp.sql b/gnuplot/by_temp.sql
new file mode 100644
index 0000000..cd936e6
--- /dev/null
+++ b/gnuplot/by_temp.sql
@@ -0,0 +1,13 @@
+select 
+	to_char(min(time), 'YYYY-MM-DD') as time,
+	avg(x_axis_angle) ,
+	avg(y_axis_angle) ,
+	avg(sensor_temperature) ,
+	round((sensor_temperature / 2)) * 2
+from zc
+where pn = 2008050087 -- and time > now() - interval '24 hours'
+group by
+	to_char(time, 'YYYY-MM-DD'),
+	round((sensor_temperature / 2)) * 2
+order by time asc 
+