Rapport: families: frequency distribution of wife's marriage age, by 5-year-steps

         Beskrivning: families: frequency distribution of wife's marriage age, by 5-year-steps one = equals 50 people

Hem    Sök    Skriv ut    Logga in    Lägg till Bokmärke

Fel: Denna rapports sök-syntax (ID: 98) var ej korrekt, och rapporten kunde därför inte skapas. Kontakta systemadministratören på ove@binatech.se.

Sök: SELECT 5*FLOOR((YEAR(f.marrdatetr)-YEAR(p.birthdatetr))/5) AS married_age_from, 5*FLOOR((YEAR(f.marrdatetr)-YEAR(p.birthdatetr))/5)+4 AS married_age_till, COUNT(*) AS Total, RPAD('',COUNT(*)/50,'=') AS Graphic FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife and b.gedcom = f.gedcom WHERE p.birthdatetr>0 AND f.marrdatetr-p.birthdatetr>0 GROUP BY married_age_from ORDER BY married_age_from
Felmeddelande: