MySQL Distinct Records With Count

Question

I have a photo table with two columns in this table with the names "id" and "user_id". Obviously, one user can have many photos. I would like to run a query that can give me the number of photos for each user.

Any help is appreciated.

Answer 1

select user_id, count(*) as photo_count from photos group by user_id

Answer 2

Using:

SELECT t.user_id,
       COUNT(*) AS photo_count
  FROM PHOTOS
GROUP BY t.user_id

Answer 3

count groupby, ,

:

SELECT user_id, count(*) 'Photos Count'
from photos
group by user_id