09.11.2022, 02:37
Hi!
Is there a way to use SQL to fetch rows/calculate aggregate values for the trend data?
The table "Trends" seems to contain metadata (name, id...) about the trends, not the actual data (?).
I would like to answer questions like "What was the average temperature last month?" or "How much water was used this day last year?".
Sincerely Robert
Is there a way to use SQL to fetch rows/calculate aggregate values for the trend data?
The table "Trends" seems to contain metadata (name, id...) about the trends, not the actual data (?).
I would like to answer questions like "What was the average temperature last month?" or "How much water was used this day last year?".
Sincerely Robert