- or download this
CREATE TABLE Geo_m_count (
...
Age_range VARCHAR(25) NULL,
Person_count INT NULL
)
- or download this
CREATE TABLE Cases (
...
Undcause varchar(10) NULL,
OAcode varchar(20) NULL
)
- or download this
FROM Cases C, Geo_m_count G WHERE G.OAcode LIKE C.OAcode AND C.Ageyea
+rs >= G.Age_start AND C.Ageyears <= G.Age_end AND C.Sex = G.Sex)