Changes between Version 24 and Version 25 of Анализа

Timestamp:

02/02/26 22:03:38 (4 days ago)

Author:

222039

Comment:

--

Анализа

@@ -45 +45 @@
 Queries:
 
-Q1
-{{{!sql
+Q1 - Range Scan 2024
+{{{
+SELECT 
+    AVG(temp) AS avg_temp,
+    AVG(humidity) AS avg_humidity,
+    AVG(speed) AS avg_wind,
+    COUNT(*) AS data_points
+FROM weatherdata_copy
+WHERE log_date >= '2024-01-01' 
+  AND log_date < '2025-01-01'
+  AND station = ${RANDOM_STATION}
+}}}
 
-TT
+Q2 - Monthly Aggregate 2023
+{{{
+SELECT 
+    YEAR(log_date) AS year,
+    MONTH(log_date) AS month,
+    COUNT(*) AS record_count,
+    AVG(temp) AS avg_temp,
+    MAX(temp) AS max_temp,
+    MIN(temp) AS min_temp,
+    STDDEV(temp) AS temp_stddev,
+    AVG(humidity) AS avg_humidity,
+    AVG(wind) AS avg_wind,
+    MAX(wind) AS max_wind
+FROM weatherdata_copy
+WHERE log_date >= '2023-01-01' 
+  AND log_date < '2024-01-01'
+GROUP BY YEAR(log_date), MONTH(log_date)
+ORDER BY year, month</stringProp>
+}}}
 
+Q3 - Recent Data
+{{{
+SELECT 
+    log_date, time, station, temp, humidity, 
+    airpressure, wind, wewather, winddirection
+FROM weatherdata_copy
+WHERE log_date &gt;= &apos;2025-01-01&apos; 
+  AND log_date &lt; &apos;2025-02-01&apos;
+  AND station = ${RANDOM_STATION}
+ORDER BY log_date DESC, time DESC
+LIMIT 1000
 }}}