Sha256: 0a15a2e68b685a399c86d6dd0c7028e529eb48ecf359717e125a88e4adc4513d

Contents?: true

Size: 271 Bytes

Versions: 8

Compression:

Stored size: 271 Bytes

Contents

select
  visitors.name as person,
  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 person, 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/individual_visitors_by_monuments_v01.sql
rails_app_generator-0.3.5 after_templates/addons/scenic/db/views/individual_visitors_by_monuments_v01.sql
rails_app_generator-0.3.4 after_templates/addons/scenic/db/views/individual_visitors_by_monuments_v01.sql
rails_app_generator-0.3.3 after_templates/addons/scenic/db/views/individual_visitors_by_monuments_v01.sql
rails_app_generator-0.3.2 after_templates/addons/scenic/db/views/individual_visitors_by_monuments_v01.sql
rails_app_generator-0.3.1 after_templates/addons/scenic/db/views/individual_visitors_by_monuments_v01.sql
rails_app_generator-0.3.0 after_templates/addons/scenic/db/views/individual_visitors_by_monuments_v01.sql
rails_app_generator-0.2.43 after_templates/addons/scenic/db/views/individual_visitors_by_monuments_v01.sql