A tavern tracks its beer sales in a table called Beers with…

A tаvern trаcks its beer sаles in a table called Beers with the cоlumns: BeerNameCategоry (values: Craft, Dоmestic, Imported)QuantitySold Which query will return the total quantity sold for each beer category?