CREATE TABLE Geo_m_count (
Cause VARCHAR(30) NULL,
OAcode VARCHAR(20) NOT NULL,
Sex FLOAT(3) NOT NULL,
Age_start INT NULL,
Age_end INT NULL,
Age_range VARCHAR(25) NULL,
Person_count INT NULL
                                                  )

##</code><code>##


CREATE TABLE Cases (
Year_of_death varchar(14) NOT NULL,
Ageyears float(8) NOT NULL,
Sex float(12) NULL,
Undcause varchar(10) NULL,
OAcode varchar(20) NULL
                                                              )

##</code><code>##


 FROM Cases C, Geo_m_count G WHERE G.OAcode LIKE C.OAcode AND C.Ageyears >= G.Age_start AND C.Ageyears <= G.Age_end AND C.Sex = G.Sex)