Im building an airbnb type app. On the home page I want to list how many properties there are in each province dynamically.
The way my db is setup is as such:
Data Type: Properties
Field for properties: PropProvince as text
Is my db set up in such a way where I could count how many occurrences of each province there are? For instance, if there are 5 properties that state they are in Quebec, could the dynamic text on the home page reflect that and say “5 homes”? Or do i need to totally restructure my db?
Ive been stuck on this for a while. Any help is appreciated!
Thanks in advance!