How to count the number of users to whom the admin replied?

Question

MySQL

How can you count the number of responses for the admin field and each repeating user was counted as one person helped by the admin

Output:
admin count_user(number of users who were helped by admin without repeating

Answer 1

SELECT admin, COUNT( DISTINCT user ) 
  FROM table
  GROUP BY admin