How to add items from a column in SQL

Question

I’d like to know how to add up those repeated items totaling their amount, I’m a beginner in SQL

select Cardapio.Indicadorsetor, Service from Cardapio,

Answer 1

I believe that this SQL sums the quantities by grouping the items:

select Cardapio.IndicadorSetor, Cardapio.NomeItem, SUM(AtendimentoItem.Quantidade)
from Cardapio,AtendimentoItem 
group by Cardapio.IndicadorSetor, Cardapio.NomeItem