How to get unique column values ​​and their number?

Question

MySQL

SELECT DISTINCT brand, age FROM productswith such a record, it gives me an object with 2 keys for brand and age, but I need their unique names in the trailer, and not uniquely grouped in pairs, because there is the uniqueness of the varieties of keys in 2 fields, which are often repeated in terms of brand names and age.
I also need their number.
SELECT DISTINCT brand, COUNT(brand) FROM products
With such a record, for some reason it displays {"brand":"Heinz","COUNT(brand)":162}

How do I get the unique field values ​​​​and their number?

Answer 1

SELECT `brand`, COUNT(*) AS `count`
  FROM `products`
  GROUP BY `brand`

And a similar query with age.