I don't even consider myself a novice especially considering how little I have to do this, but with google and searching EE I can usually figure this stuff out - so far, not this time.
I have this table
and I need to pull out the average value for every day, of TagID 3006, over the course of several years.
It sounds so easy but I cant figure out how to "nest" a query like that.
...presuming the column named Value is the average for the day. Otherwise, there may not be enough information to answer the question.
Also, naming a column "Value" is a worst practice.