Report: Statistics of places where people were baptized

From TNG_Wiki
Jump to navigation Jump to search

Description: Statistics of places where people were baptized. One = is 100 people

Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate

SELECT REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(altbirthplace,",",2)),",",1)) as gemeente_or_state, COUNT(*) AS Number, RPAD(' ',COUNT(*)/100,'=') AS Graph FROM tng_people WHERE altbirthplace <> "" group BY gemeente_or_state order by Number desc