Hi,
I have a a very basic query : "Select Tbl_customer, Tbl_city from Orders",
but I want to add, using the Expression builder, another field that shows me the number of times each city appears on record. For example, if New York appears 5 times, London 4 times, etc, I want the query to show that.
How do I do that?
Thanks in advance!