# -------------------------------------------------------------
# sample for xtab.pl
# creates a cross-tabulation having age-ranges as rows 
# and gender items as columns
# -------------------------------------------------------------
# usage: perl xtab.pl < age-gender-count.xtab [| mysql -t ]
# -------------------------------------------------------------title=age-gender
database=xcompany
row_name=CASE WHEN YEAR(DOB) BETWEEN 1940 AND 1950 THEN '50-60' WHEN YEAR(DOB) BETWEEN 1951 AND 1960 THEN '40-49' WHEN YEAR(DOB) BETWEEN 1961 AND 1970 THEN '30-39' WHEN YEAR(DOB) BETWEEN 1970 and 1980 THEN '20-29' END
row_alias=age
col_name=gender
col_alias=gender
col_value=1
col_from=FROM employees
col_where=
col_order= 
row_from=FROM employees 
row_where=
row_order=
row_group=GROUP BY age