Separate Rows by group and their percentage of total

Question

I need to get the top 10 results that appear in my table and their respective percentages by groups. For example the table:

+-----+-----+
|id   |fruit|
+-----+-----+
|  1  | or  |
|  2  | ban |
|  3  | or  |
|  4  | or  |
+-----+-----+

he would have to return me something like:

+-----+-----+-----+
|COUNT|fruit|PERCE|
+-----+-----+-----+
|  3  | or  | 90% |
|  1  | ban | 10% |
+-----+-----+-----+

90% because it represents 90% of the total Rows and so on

Answer 1

You need to tell everything, group by fruit and sort by the count of each group, limiting to 10. Thus:

select count(id) as contagem, fruit, 
    concat(format((count(fruit) * 100 / (select count(*) from tabela)), 0), '%') as percentagem
from tabela
group by fruit desc
limit 10

I put in the Github for future reference.