troubleshooting Question

Average each day over years

Avatar of Salad-Dodger
Salad-DodgerFlag for United States of America asked on
SQL
10 Comments2 Solutions110 ViewsLast Modified:
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 table2017-11-27_9-59-19.jpg
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros