I have a table where I keep data for multiple hotels where I hae the following rows
- Year
- month
- country of origin
- nationality criteria - this field has only 2 options, "f" for foreign and "d" for domestic
- hotel
- number of guests
- number of nightings
I made a query that returns all...