How to create a grouped view like sql group by and sum

I hvae a table:
id type score
1 a 10
2 a 15
3 b 20

how to get a view as below:
type sum
a 25
b 20

Hi @Wen_Le,

I assume that the below is what you are looking for:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.