Continent: Difference between revisions

Jump to navigation Jump to search
Line 58: Line 58:
|where=historic='No' AND ecclesiastical_provinces_count IS NOT NULL
|where=historic='No' AND ecclesiastical_provinces_count IS NOT NULL
|order by=SUM(ecclesiastical_provinces_count) DESC
|order by=SUM(ecclesiastical_provinces_count) DESC
|format=bar chart
}}
=== Countries with Catholicism as State Religion ===
Count countries where Catholicism is the state religion or dominant, grouped by continent.
{{#cargo_query:
tables=Countries
|fields=continent=Continent,COUNT(*)=Countries_with_State_Catholicism
|where=catholicism_status LIKE '%State religion%' AND historic='No'
|group by=continent
|having=COUNT(*) > 0
|order by=COUNT(*) DESC
|format=bar chart
|format=bar chart
}}
}}

Navigation menu