Ok so this is kinda weird I'm not sure how to exactly tackle it without it being a massive query, that might be slow so this is the tables as it is
Concerts: name | country_id | ticket_price foo 2 50 bar 1 40 Country: id | name 1 UK 2 US Region: id | name 1 EU 2 America Country_Region: id | country_id | region_id 1 1 1 2 2 2
of course this is fictitious data/ schema but it does exactly what the real one does, I need to keep the country/region as a many to many so now what I need to do is get an avarage of say the ticket_price per month per region.
I'm really not sure how to get that query.
Edit: I should also point out that there aren't just 2 regions and more can be added the whole time and country within them changed.