SQL Distinct Count on Multiple Columns

Question

I am new to SQL so don't know much about it. Please help. I have a database something like this:

User    Model
A        X
A        X
A        X
B        Y
C        Y
C        Y
D        X
D        X
E        Z....

I want to calculate the frequency of the each unique model respective to unique users. I mean the output should be something like this:

Model    Count
 X         2
 Y         2
 Z         1

as A and D use model X, so X=2. Similarly B and C use model Y, so Y=2. and same goes for Z(only user E). How do I achieve this?

Vamsi Prabhala · Accepted Answer · 2018-02-09 16:46:57Z

4

Use group by.

select model,count(distinct user)
from tbl
group by model

answered Feb 9, 2018 at 16:46

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

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

1 Answer 1