Need to write SQL request

I have tables, which you can see here.

http://ift.tt/1KTDU9o diagram
http://ift.tt/1KTDU9q rails 4 migrations

I need to write request with sql syntax or ruby active record syntax. I need to get
* Country name or region name or city name
* Amount of hotels in this country

Output E.g. :  
  USA 6             
  Florida 2         
  New-york 4        
  UK 2              
  London 2