Querry Count Rows

[Tomas Abad]

Hi all,

 

I have a table with ordes and i want to know the top 10 Citys have the most
ordes. This is my table

 

Order_id, City

 

Need count the rows where haver the most similar text y the column City?

 

 

Thanks all