mysql query data group

I have a mysql table like that

and i need开发者_开发知识库 to run a query which will output the following result

what will be mysql query for that?any suggestions please?

---

You need to use a GROUP BY.

SELECT data, count(*) 
FROM   your_table 
GROUP BY 
       data