Contents

select
  monuments.name as monument,
  countries.name as country,
  count(*) as visits
from visitors
join monuments on visitors.monument_id = monuments.id
join countries on monuments.country_id = countries.id
group by monument, country

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
rails_app_generator-0.3.6	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql
rails_app_generator-0.3.5	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql
rails_app_generator-0.3.4	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql
rails_app_generator-0.3.3	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql
rails_app_generator-0.3.2	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql
rails_app_generator-0.3.1	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql
rails_app_generator-0.3.0	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql
rails_app_generator-0.2.43	after_templates/addons/scenic/db/views/visitors_by_monuments_v01.sql