java – How to prevent the repetition of the same value in a SQLite query

I have a query to my SQLite database, which returns the description of an article (eg: Cocacola) and a price.

What I would like, is that instead of returning each line with the article and its price, I return the article that is repeated, the number of repetitions and the sum of the price.


Cocacola, 20, 1.50×20.

I know that I have to use SUM () for the price, but to receive only the description once, I do not know how to do it and the number of times it is repeated in the query.