Report: families: occuring marriage types without names (but with frequency)

From TNG_Wiki
Jump to navigation Jump to search

Description: families: occuring marriage types without names (but with frequency). One = equals 5 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 marrtype AS marriage_type, COUNT(*) AS Totals, RPAD('',COUNT(*)/5,'=') AS Graph FROM tng_families WHERE marrtype<>'' GROUP BY marrtype ORDER BY marrtype