Wapug
Registered User.
- Local time
- Today, 16:52
- Joined
- Apr 14, 2017
- Messages
- 51
I am trying to create a query that looks at a table to find the average score for each day. I need to query the table and find the Distinct dates, these could be multiple records with the same date but different scores, and then average the score and end up with my Date & average score for the day. For example:
ID DATE SCORE
3 8/1/18 95.60
7 8/2/18 93.95
9 8/1/18 86.32
13 8/1/18 75.90
RESULT:
DATE SCORE
8/1/18 85.94
8/2/18 93.95
ID DATE SCORE
3 8/1/18 95.60
7 8/2/18 93.95
9 8/1/18 86.32
13 8/1/18 75.90
RESULT:
DATE SCORE
8/1/18 85.94
8/2/18 93.95