Simple SQL Average

Question

I have a select statements that outputs this:

[Total Days]
[991]
[127]
[664]
[889]

These values represent the total days each customer is registered. In this example I used 4 records, so to get the avarage I need to do ((991 + 127 + 664 + 889 ) / 4).

How to I achieve such thing in SQL?

Why your title is about `Count` if you are looking for `avg`? — Jens, May 16 '17 at 13:47
Possible duplicate of [SQL query with avg and group by](http://stackoverflow.com/questions/10702546/sql-query-with-avg-and-group-by) — Alexander, May 16 '17 at 13:52
Simply googling "sql average" would have given you your answer. — Josh B, May 16 '17 at 14:32

SandPiper · Answer 1 · 2017-05-16T13:53:10.210

1

SELECT AVG(Total_Days) AS Total_Days_Average FROM MyTable

edited May 16 '17 at 13:53

answered May 16 '17 at 13:49

SandPiper

2,816
5
30
52

2

Don't you mean `AVG()`? – jarlh May 16 '17 at 13:52

score 0 · Answer 2 · answered May 16 '17 at 14:07

0

Use below query,

SELECT (SUM(TOTAL_DAYS)/4) FROM TABLE_NAME;

answered May 16 '17 at 14:07

Jim Macaulay

4,709
4
28
53

Simple SQL Average

2 Answers2