query to create a population pyramid from Census data

create_female_pop_pyramid.sql

SELECT
  SUM(PCT0120107+PCT0120108+PCT0120109+PCT0120110+PCT0120111) AS "0-4",
  SUM(PCT0120112+PCT0120113+PCT0120114+PCT0120115+PCT0120116) AS "5-9",
  SUM(PCT0120117+PCT0120118+PCT0120119+PCT0120120+PCT0120121) AS "10-14",
  SUM(PCT0120122+PCT0120123+PCT0120124+PCT0120125+PCT0120126) AS "15-19",
  SUM(PCT0120127+PCT0120128+PCT0120129+PCT0120130+PCT0120131) AS "20-24",
  SUM(PCT0120132+PCT0120133+PCT0120134+PCT0120135+PCT0120136) AS "25-29",
  SUM(PCT0120137+PCT0120138+PCT0120139+PCT0120140+PCT0120141) AS "30-34",
  SUM(PCT0120142+PCT0120143+PCT0120144+PCT0120145+PCT0120146) AS "35-39",
  SUM(PCT0120147+PCT0120148+PCT0120149+PCT0120150+PCT0120151) AS "40-44",
  SUM(PCT0120152+PCT0120153+PCT0120154+PCT0120155+PCT0120156) AS "45-49",
  SUM(PCT0120157+PCT0120158+PCT0120159+PCT0120160+PCT0120161) AS "50-54",
  SUM(PCT0120162+PCT0120163+PCT0120164+PCT0120165+PCT0120166) AS "55-59",
  SUM(PCT0120167+PCT0120168+PCT0120169+PCT0120170+PCT0120171) AS "60-64",
  SUM(PCT0120172+PCT0120173+PCT0120174+PCT0120175+PCT0120176) AS "65-69",
  SUM(PCT0120177+PCT0120178+PCT0120179+PCT0120180+PCT0120181) AS "70-74",
  SUM(PCT0120182+PCT0120183+PCT0120184+PCT0120185+PCT0120186) AS "75-79",
  SUM(PCT0120187+PCT0120188+PCT0120189+PCT0120190+PCT0120191) AS "80-84",
  SUM(PCT0120192+PCT0120193+PCT0120194+PCT0120195+PCT0120196) AS "85-89",
  SUM(PCT0120197+PCT0120198+PCT0120199+PCT0120200+PCT0120201) AS "90-94",
  SUM(PCT0120202+PCT0120203+PCT0120204+PCT0120205+PCT0120206) AS "95-99",
  SUM(PCT0120207+PCT0120208+PCT0120209) AS "100+"
FROM sf1_00017 sf,
 (SELECT logrecno
FROM 
  geo_header_sf1 g, 
  (SELECT "TRACTCE10","NAMELSAD10","COUNTYFP10" from tract_d3) t (tractce10, namelsad10,countyfp10 )
WHERE
  g.tract = t.tractce10 AND g.sumlev='140' 
AND g.name=t.namelsad10 
AND g.county=t.countyfp10
) as geo (logrecno)
WHERE 
 sf.logrecno = geo.logrecno;