mysql count query

I have a mysql table set up like this 开发者_如何学JAVA

id | refference_id | data

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

---

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

---

select count(distinct refference_id) as myResult from myTable;