SQL query averaging by name

Question

I have this below data:

    criteria    rating

    Criteria1   3
    Criteria2   3
    Criteria3   3
    Criteria5   3
    Criteria1   5
    Criteria2   5
    Criteria3   5
    Criteria5   1

i want to take average of rating each by criteria name like :

expected output:

    criteria    rating

    Criteria1   4
    Criteria2   4
    Criteria3   4
    Criteria5   2

Can anybody help me achieving that?

What was the problem? Simple `Group By` & `Avg` will do the work. — Shakeer Mirza, Jul 10 '18 at 09:05
Possible duplicate of [Average of grouped rows in Sql Server](https://stackoverflow.com/questions/3100921/average-of-grouped-rows-in-sql-server) — Mani Deep, Jul 10 '18 at 09:51

score 1 · Answer 1 · answered Jul 10 '18 at 09:06

1

Select criteria, avg(rating) as rating from tbl group by criteria

answered Jul 10 '18 at 09:06

Ajay Gupta

1,775
1
10
22

score 0 · Answer 2 · answered Jul 10 '18 at 09:05

0

This should do the work:

SELECT criteria, AVG(rating) FROM <table_name>
GROUP BY criteria;

answered Jul 10 '18 at 09:05

bcap

500
5
14

score 0 · Answer 3 · answered Jul 10 '18 at 09:06

0

SELECT Criteria, 
        AVG(rating) 
             From YourTable 
             GROUP BY Criteria 
             ORDER BY Criteria

answered Jul 10 '18 at 09:06

Cato

3,652
9
12

SQL query averaging by name

3 Answers3