Select Distinct and Count on the same query MySQL

Question

I have a table products, and each product has a specific brand.

What I want to do is to count the times a specific brand has appeared and, together, show the unique product it has.

For example:

Table products

ID, ProductName, Brand
1, TV, Samsung
2, TV, Sony
3, TV, Samsung
4, Phone, Sony

The query should result:

ProductName, Brand, Count
TV, Samsung, 2
TV, Sony, 1
Phone, Sony, 1

Can you help?

Sorry I'm writing on a phone and on the bus that's why I didn't specify but please feel free to ask if you didn't understand.

This is really basic aggregation, any SQL tutorial should explain how to do it. — Barmar
– Barmar, Commented Jun 14, 2018 at 21:51
Thanks! Wouldn't ask here if I found on Google, with all due respect. Was trying to use distinct but realized it was unnecessary. — spaceman
– spaceman, Commented Jun 14, 2018 at 22:21

Tik · Accepted Answer · 2018-06-14 21:49:18Z

3

Easy with Group by

SELECT productName, Brand, COUNT(*)
FROM yourdb
GROUP BY productName, Brand

answered Jun 14, 2018 at 21:49

Tik

8826 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks! Was using distinct but I've realized it is unnecessary.

greendemiurge · Accepted Answer · 2018-06-14 21:51:28Z

2

Give this a try:

 SELECT ProductName, Brand, count(id) AS Count FROM products GROUP BY ProductName, Brand

answered Jun 14, 2018 at 21:51

greendemiurge

5493 silver badges11 bronze badges

Thanks! Am giving you the correct answer for the quickness.