Continent: Difference between revisions

Line 38: Line 38:
|having=COUNT(*) > 2
|having=COUNT(*) > 2
|order by=SUM(catholic_population) DESC
|order by=SUM(catholic_population) DESC
|format=bar chart
}}
=== Total Number of Dioceses ===
{{#cargo_query:
tables=Countries
|fields=continent=Continent,SUM(dioceses_count)=Total_Dioceses
|group by=continent
|having=COUNT(*) > 2
|where=historic='No' AND dioceses_count IS NOT NULL
|order by=SUM(dioceses_count) DESC
|format=bar chart
|format=bar chart
}}
}}