select item, count(*)
from mytable
group by item