mysql query data group

I have a mysql table like that

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