mysql - SQL 查询按名称平均

Question

我有以下数据:

    criteria    rating

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

我想按标准名称对每个评分取平均值，例如:

预期输出:

    criteria    rating

    Criteria1   4
    Criteria2   4
    Criteria3   4
    Criteria5   2

有人可以帮我实现吗？

Answer 1

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