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: