Average Multiple Scores for Day (1 Viewer)

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
 

Wapug

Registered User.
Local time
Today, 16:52
Joined
Apr 14, 2017
Messages
51
Sorry I wanted to post my example a bit different

DATE SCORE
8/1/18 95.60
8/2/18 93.95
8/1/18 86.32
8/1/18 75.90

RESULT:
DATE SCORE
8/1/18 85.94
8/2/18 93.95
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:52
Joined
Sep 21, 2011
Messages
14,260
Just group by date and AVG() the score.
I used my Emails table to test.

HTH

Code:
SELECT Emails.TransactionDate, Avg(Emails.Score) AS AvgOfScore
FROM Emails
GROUP BY Emails.TransactionDate
 

Users who are viewing this thread

Top Bottom