This is probably very simple, but my brain is stuck, and I'm a newbie 😕
I have a database with tour date and cities for a band.
In the database they maybe play 5 times in one city and 2 times in another.
Now I have two problems, I want it to write have many time they play in the cities.
New York 2 times
Los Angeles 5 times
etc.
And the the next question is how to write them in order, so the most visited city is written first etc.
So this is two questions.
1. How do I count how many times the cities is in the database.
2. How do I sort them afterward.
Hope you can help.