mysql count query

Question

I have a mysql table set up like this

id | refference_id | data

Is it possible to count the number of entries for each refference_id all in the query ?

Answer 1

SELECT
  refference_id,
  COUNT(*)
FROM
  table
GROUP BY
  refference_id 

Answer 2

select count(distinct refference_id) as myResult from myTable;