-- drop table if exists RainRecord;

CREATE TABLE `RainRecord` (
  `year` varchar(255) default NULL,
  `month` varchar(255) default NULL,
  `rain` double default NULL,
  `color` varchar(255) default NULL,
   primary key(year,month)
);

insert into `RainRecord` values('1888','JAN',null,null);
insert into `RainRecord` values('1889','JAN','1.24',null);
insert into `RainRecord` values('1890','JAN','29.4',null);
insert into `RainRecord` values('1891','JAN','2.46',null);
insert into `RainRecord` values('1892','JAN','4.6',null);
insert into `RainRecord` values('1893','JAN','10.04',null);
insert into `RainRecord` values('1894','JAN','14.92',null);
insert into `RainRecord` values('1895','JAN','12.56',null);
insert into `RainRecord` values('1896','JAN','26.86',null);
insert into `RainRecord` values('1897','JAN','3.17',null);
insert into `RainRecord` values('1898','JAN','1.91',null);
insert into `RainRecord` values('1899','JAN','20.15',null);
insert into `RainRecord` values('1900','JAN','11.06',null);
insert into `RainRecord` values('1901','JAN','12.09',null);
insert into `RainRecord` values('1902','JAN','3.35',null);
insert into `RainRecord` values('1903','JAN','11.14',null);
insert into `RainRecord` values('1904','JAN','2.98',null);
insert into `RainRecord` values('1905','JAN','8.58',null);
insert into `RainRecord` values('1906','JAN','26.71',null);
insert into `RainRecord` values('1907','JAN','13.87',null);
insert into `RainRecord` values('1908','JAN','7.22',null);
insert into `RainRecord` values('1909','JAN','39.42',null);
insert into `RainRecord` values('1910','JAN','8.4',null);
insert into `RainRecord` values('1911','JAN','33.95',null);
insert into `RainRecord` values('1912','JAN','7.48',null);
insert into `RainRecord` values('1913','JAN','9.3',null);
insert into `RainRecord` values('1914','JAN','30.39',null);
insert into `RainRecord` values('1915','JAN','14.43',null);
insert into `RainRecord` values('1916','JAN','27.43',null);
insert into `RainRecord` values('1888','FEB',null,null);
insert into `RainRecord` values('1889','FEB','1.8',null);
insert into `RainRecord` values('1890','FEB','10.62',null);
insert into `RainRecord` values('1891','FEB','34.03',null);
insert into `RainRecord` values('1892','FEB','9.51',null);
insert into `RainRecord` values('1893','FEB','9.57',null);
insert into `RainRecord` values('1894','FEB','13.87',null);
insert into `RainRecord` values('1895','FEB','4.4',null);
insert into `RainRecord` values('1896','FEB','0.24',null);
insert into `RainRecord` values('1897','FEB','10.41',null);
insert into `RainRecord` values('1898','FEB','8.26',null);
insert into `RainRecord` values('1899','FEB','0.62',null);
insert into `RainRecord` values('1900','FEB','0.93',null);
insert into `RainRecord` values('1901','FEB','11.53',null);
insert into `RainRecord` values('1902','FEB','25.42',null);
insert into `RainRecord` values('1903','FEB','4.66',null);
insert into `RainRecord` values('1904','FEB','18.33',null);
insert into `RainRecord` values('1905','FEB','10.49',null);
insert into `RainRecord` values('1906','FEB','10',null);
insert into `RainRecord` values('1907','FEB','3.62',null);
insert into `RainRecord` values('1908','FEB','10.68',null);
insert into `RainRecord` values('1909','FEB','15.29',null);
insert into `RainRecord` values('1910','FEB','4.22',null);
insert into `RainRecord` values('1911','FEB','6.26',null);
insert into `RainRecord` values('1912','FEB','0.57',null);
insert into `RainRecord` values('1913','FEB','0.29',null);
insert into `RainRecord` values('1914','FEB','9.06',null);
insert into `RainRecord` values('1915','FEB','21.62',null);
insert into `RainRecord` values('1916','FEB','6.83',null);
insert into `RainRecord` values('1888','MAR',null,null);
insert into `RainRecord` values('1889','MAR','19.58',null);
insert into `RainRecord` values('1890','MAR','11.77',null);
insert into `RainRecord` values('1891','MAR','5.57',null);
insert into `RainRecord` values('1892','MAR','11.29',null);
insert into `RainRecord` values('1893','MAR','16.91',null);
insert into `RainRecord` values('1894','MAR','2.11',null);
insert into `RainRecord` values('1895','MAR','5.89',null);
insert into `RainRecord` values('1896','MAR','4.25',null);
insert into `RainRecord` values('1897','MAR','11.56',null);
insert into `RainRecord` values('1898','MAR','1.06',null);
insert into `RainRecord` values('1899','MAR','24.49',null);
insert into `RainRecord` values('1900','MAR','5.49',null);
insert into `RainRecord` values('1901','MAR','1.65',null);
insert into `RainRecord` values('1902','MAR','8.54',null);
insert into `RainRecord` values('1903','MAR','14.9',null);
insert into `RainRecord` values('1904','MAR','17.2',null);
insert into `RainRecord` values('1905','MAR','8.57',null);
insert into `RainRecord` values('1906','MAR','18.96',null);
insert into `RainRecord` values('1907','MAR','25.28',null);
insert into `RainRecord` values('1908','MAR','2.01',null);
insert into `RainRecord` values('1909','MAR','8.48',null);
insert into `RainRecord` values('1910','MAR','10.46',null);
insert into `RainRecord` values('1911','MAR','10.39',null);
insert into `RainRecord` values('1912','MAR','7.87',null);
insert into `RainRecord` values('1913','MAR','3.93',null);
insert into `RainRecord` values('1914','MAR','1.4',null);
insert into `RainRecord` values('1915','MAR','5.34',null);
insert into `RainRecord` values('1916','MAR','3.76',null);
insert into `RainRecord` values('1888','APR',null,null);
insert into `RainRecord` values('1889','APR','0.39',null);
insert into `RainRecord` values('1890','APR','2.29',null);
insert into `RainRecord` values('1891','APR','6.81',null);
insert into `RainRecord` values('1892','APR','1.99',null);
insert into `RainRecord` values('1893','APR','3.49',null);
insert into `RainRecord` values('1894','APR','2.44',null);
insert into `RainRecord` values('1895','APR','3.55',null);
insert into `RainRecord` values('1896','APR','8.47',null);
insert into `RainRecord` values('1897','APR','0.69',null);
insert into `RainRecord` values('1898','APR','0.6',null);
insert into `RainRecord` values('1899','APR','1.64',null);
insert into `RainRecord` values('1900','APR','1.75',null);
insert into `RainRecord` values('1901','APR','5.48',null);
insert into `RainRecord` values('1902','APR','4.13',null);
insert into `RainRecord` values('1903','APR','2.94',null);
insert into `RainRecord` values('1904','APR','4.02',null);
insert into `RainRecord` values('1905','APR','2.07',null);
insert into `RainRecord` values('1906','APR','1.63',null);
insert into `RainRecord` values('1907','APR','0.82',null);
insert into `RainRecord` values('1908','APR','0.56',null);
insert into `RainRecord` values('1909','APR','0',null);
insert into `RainRecord` values('1910','APR','1.21',null);
insert into `RainRecord` values('1911','APR','4.04',null);
insert into `RainRecord` values('1912','APR','3.57',null);
insert into `RainRecord` values('1913','APR','0.67',null);
insert into `RainRecord` values('1914','APR','2.24',null);
insert into `RainRecord` values('1915','APR','3.39',null);
insert into `RainRecord` values('1916','APR','0',null);
insert into `RainRecord` values('1888','MAY',null,null);
insert into `RainRecord` values('1889','MAY','4.78',null);
insert into `RainRecord` values('1890','MAY','1.6',null);
insert into `RainRecord` values('1891','MAY','2.4',null);
insert into `RainRecord` values('1892','MAY','6.03',null);
insert into `RainRecord` values('1893','MAY','0.65',null);
insert into `RainRecord` values('1894','MAY','3.26',null);
insert into `RainRecord` values('1895','MAY','1.83',null);
insert into `RainRecord` values('1896','MAY','1.81',null);
insert into `RainRecord` values('1897','MAY','0',null);
insert into `RainRecord` values('1898','MAY','2.82',null);
insert into `RainRecord` values('1899','MAY','0.24',null);
insert into `RainRecord` values('1900','MAY','1.34',null);
insert into `RainRecord` values('1901','MAY','2.52',null);
insert into `RainRecord` values('1902','MAY','1.15',null);
insert into `RainRecord` values('1903','MAY','0',null);
insert into `RainRecord` values('1904','MAY','0.37',null);
insert into `RainRecord` values('1905','MAY','6.02',null);
insert into `RainRecord` values('1906','MAY','7.23',null);
insert into `RainRecord` values('1907','MAY','0.14',null);
insert into `RainRecord` values('1908','MAY','0.89',null);
insert into `RainRecord` values('1909','MAY','0',null);
insert into `RainRecord` values('1910','MAY','0',null);
insert into `RainRecord` values('1911','MAY','0.53',null);
insert into `RainRecord` values('1912','MAY','2.77',null);
insert into `RainRecord` values('1913','MAY','0.73',null);
insert into `RainRecord` values('1914','MAY','0.97',null);
insert into `RainRecord` values('1915','MAY','8.15',null);
insert into `RainRecord` values('1916','MAY','0.02',null);
insert into `RainRecord` values('1888','JUN',null,null);
insert into `RainRecord` values('1889','JUN','0',null);
insert into `RainRecord` values('1890','JUN','0',null);
insert into `RainRecord` values('1891','JUN','0',null);
insert into `RainRecord` values('1892','JUN','0',null);
insert into `RainRecord` values('1893','JUN','0',null);
insert into `RainRecord` values('1894','JUN','0.39',null);
insert into `RainRecord` values('1895','JUN','0',null);
insert into `RainRecord` values('1896','JUN','0',null);
insert into `RainRecord` values('1897','JUN','0.71',null);
insert into `RainRecord` values('1898','JUN','0.46',null);
insert into `RainRecord` values('1899','JUN','2.53',null);
insert into `RainRecord` values('1900','JUN','0',null);
insert into `RainRecord` values('1901','JUN','0',null);
insert into `RainRecord` values('1902','JUN','0.5',null);
insert into `RainRecord` values('1903','JUN','0',null);
insert into `RainRecord` values('1904','JUN','0',null);
insert into `RainRecord` values('1905','JUN','0',null);
insert into `RainRecord` values('1906','JUN','1',null);
insert into `RainRecord` values('1907','JUN','0.69',null);
insert into `RainRecord` values('1908','JUN','0',null);
insert into `RainRecord` values('1909','JUN','0.17',null);
insert into `RainRecord` values('1910','JUN','0',null);
insert into `RainRecord` values('1911','JUN','0',null);
insert into `RainRecord` values('1912','JUN','0.75',null);
insert into `RainRecord` values('1913','JUN','0.11',null);
insert into `RainRecord` values('1914','JUN','0.68',null);
insert into `RainRecord` values('1915','JUN','0',null);
insert into `RainRecord` values('1916','JUN','0',null);
insert into `RainRecord` values('1888','JUL','0.01',null);
insert into `RainRecord` values('1889','JUL','0',null);
insert into `RainRecord` values('1890','JUL','0',null);
insert into `RainRecord` values('1891','JUL','0.08',null);
insert into `RainRecord` values('1892','JUL','0',null);
insert into `RainRecord` values('1893','JUL','0',null);
insert into `RainRecord` values('1894','JUL','0',null);
insert into `RainRecord` values('1895','JUL','0',null);
insert into `RainRecord` values('1896','JUL','0.07',null);
insert into `RainRecord` values('1897','JUL','0',null);
insert into `RainRecord` values('1898','JUL','0',null);
insert into `RainRecord` values('1899','JUL','0',null);
insert into `RainRecord` values('1900','JUL','0',null);
insert into `RainRecord` values('1901','JUL','0',null);
insert into `RainRecord` values('1902','JUL','0',null);
insert into `RainRecord` values('1903','JUL','0',null);
insert into `RainRecord` values('1904','JUL',null,null);
insert into `RainRecord` values('1905','JUL','0',null);
insert into `RainRecord` values('1906','JUL','0',null);
insert into `RainRecord` values('1907','JUL','0',null);
insert into `RainRecord` values('1908','JUL','0',null);
insert into `RainRecord` values('1909','JUL','0',null);
insert into `RainRecord` values('1910','JUL','0',null);
insert into `RainRecord` values('1911','JUL','0',null);
insert into `RainRecord` values('1912','JUL','0',null);
insert into `RainRecord` values('1913','JUL','0.17',null);
insert into `RainRecord` values('1914','JUL','0',null);
insert into `RainRecord` values('1915','JUL','0',null);
insert into `RainRecord` values('1916','JUL','0',null);
insert into `RainRecord` values('1888','AUG','0.07',null);
insert into `RainRecord` values('1889','AUG','0',null);
insert into `RainRecord` values('1890','AUG','0',null);
insert into `RainRecord` values('1891','AUG','0',null);
insert into `RainRecord` values('1892','AUG','0',null);
insert into `RainRecord` values('1893','AUG','0',null);
insert into `RainRecord` values('1894','AUG','0',null);
insert into `RainRecord` values('1895','AUG','0',null);
insert into `RainRecord` values('1896','AUG','0.94',null);
insert into `RainRecord` values('1897','AUG','0',null);
insert into `RainRecord` values('1898','AUG','0',null);
insert into `RainRecord` values('1899','AUG','0',null);
insert into `RainRecord` values('1900','AUG','0',null);
insert into `RainRecord` values('1901','AUG','0',null);
insert into `RainRecord` values('1902','AUG','0',null);
insert into `RainRecord` values('1903','AUG','0',null);
insert into `RainRecord` values('1904','AUG','0.38',null);
insert into `RainRecord` values('1905','AUG','0',null);
insert into `RainRecord` values('1906','AUG','0',null);
insert into `RainRecord` values('1907','AUG','0.03',null);
insert into `RainRecord` values('1908','AUG','0',null);
insert into `RainRecord` values('1909','AUG','0.03',null);
insert into `RainRecord` values('1910','AUG','0',null);
insert into `RainRecord` values('1911','AUG','0',null);
insert into `RainRecord` values('1912','AUG','0',null);
insert into `RainRecord` values('1913','AUG','0',null);
insert into `RainRecord` values('1914','AUG','0',null);
insert into `RainRecord` values('1915','AUG','0',null);
insert into `RainRecord` values('1916','AUG','0',null);
insert into `RainRecord` values('1888','SEP','0.51',null);
insert into `RainRecord` values('1889','SEP','0',null);
insert into `RainRecord` values('1890','SEP','0.3',null);
insert into `RainRecord` values('1891','SEP','1.17',null);
insert into `RainRecord` values('1892','SEP','0.39',null);
insert into `RainRecord` values('1893','SEP','0.57',null);
insert into `RainRecord` values('1894','SEP','2.62',null);
insert into `RainRecord` values('1895','SEP','0.17',null);
insert into `RainRecord` values('1896','SEP','0.37',null);
insert into `RainRecord` values('1897','SEP',null,null);
insert into `RainRecord` values('1898','SEP','2.06',null);
insert into `RainRecord` values('1899','SEP','0',null);
insert into `RainRecord` values('1900','SEP','0.05',null);
insert into `RainRecord` values('1901','SEP','1.68',null);
insert into `RainRecord` values('1902','SEP','0',null);
insert into `RainRecord` values('1903','SEP','0',null);
insert into `RainRecord` values('1904','SEP','9.1',null);
insert into `RainRecord` values('1905','SEP',null,null);
insert into `RainRecord` values('1906','SEP','0.21',null);
insert into `RainRecord` values('1907','SEP','0.49',null);
insert into `RainRecord` values('1908','SEP','0.1',null);
insert into `RainRecord` values('1909','SEP','1.39',null);
insert into `RainRecord` values('1910','SEP',null,null);
insert into `RainRecord` values('1911','SEP','0',null);
insert into `RainRecord` values('1912','SEP','1.94',null);
insert into `RainRecord` values('1913','SEP','0',null);
insert into `RainRecord` values('1914','SEP','0',null);
insert into `RainRecord` values('1915','SEP','0',null);
insert into `RainRecord` values('1916','SEP','0.55',null);
insert into `RainRecord` values('1888','OCT','0',null);
insert into `RainRecord` values('1889','OCT','19.68',null);
insert into `RainRecord` values('1890','OCT','0',null);
insert into `RainRecord` values('1891','OCT','0.03',null);
insert into `RainRecord` values('1892','OCT','2.2',null);
insert into `RainRecord` values('1893','OCT','0.54',null);
insert into `RainRecord` values('1894','OCT','6.7',null);
insert into `RainRecord` values('1895','OCT','0.65',null);
insert into `RainRecord` values('1896','OCT','2.57',null);
insert into `RainRecord` values('1897','OCT','4.12',null);
insert into `RainRecord` values('1898','OCT','1.07',null);
insert into `RainRecord` values('1899','OCT','9.18',null);
insert into `RainRecord` values('1900','OCT','4.7',null);
insert into `RainRecord` values('1901','OCT','2.17',null);
insert into `RainRecord` values('1902','OCT','4.16',null);
insert into `RainRecord` values('1903','OCT','1.46',null);
insert into `RainRecord` values('1904','OCT','8.7',null);
insert into `RainRecord` values('1905','OCT','0',null);
insert into `RainRecord` values('1906','OCT','0',null);
insert into `RainRecord` values('1907','OCT','3.52',null);
insert into `RainRecord` values('1908','OCT','1.14',null);
insert into `RainRecord` values('1909','OCT','1.56',null);
insert into `RainRecord` values('1910','OCT','1.72',null);
insert into `RainRecord` values('1911','OCT','0.25',null);
insert into `RainRecord` values('1912','OCT','0.38',null);
insert into `RainRecord` values('1913','OCT','0',null);
insert into `RainRecord` values('1914','OCT','1.72',null);
insert into `RainRecord` values('1915','OCT','0',null);
insert into `RainRecord` values('1916','OCT','1.54',null);
insert into `RainRecord` values('1888','NOV','11.07',null);
insert into `RainRecord` values('1889','NOV','9.56',null);
insert into `RainRecord` values('1890','NOV','0.25',null);
insert into `RainRecord` values('1891','NOV','1.06',null);
insert into `RainRecord` values('1892','NOV','12.79',null);
insert into `RainRecord` values('1893','NOV','0.6',null);
insert into `RainRecord` values('1894','NOV','1.76',null);
insert into `RainRecord` values('1895','NOV','3.08',null);
insert into `RainRecord` values('1896','NOV','10.93',null);
insert into `RainRecord` values('1897','NOV','1.26',null);
insert into `RainRecord` values('1898','NOV','0.62',null);
insert into `RainRecord` values('1899','NOV','7.09',null);
insert into `RainRecord` values('1900','NOV','13.13',null);
insert into `RainRecord` values('1901','NOV','6.03',null);
insert into `RainRecord` values('1902','NOV','6.52',null);
insert into `RainRecord` values('1903','NOV','12.61',null);
insert into `RainRecord` values('1904','NOV','1.99',null);
insert into `RainRecord` values('1905','NOV','4.97',null);
insert into `RainRecord` values('1906','NOV','4.57',null);
insert into `RainRecord` values('1907','NOV','0',null);
insert into `RainRecord` values('1908','NOV','2.63',null);
insert into `RainRecord` values('1909','NOV','3.5',null);
insert into `RainRecord` values('1910','NOV','0.77',null);
insert into `RainRecord` values('1911','NOV','1.25',null);
insert into `RainRecord` values('1912','NOV','1.77',null);
insert into `RainRecord` values('1913','NOV','9.47',null);
insert into `RainRecord` values('1914','NOV','0.05',null);
insert into `RainRecord` values('1915','NOV','2.14',null);
insert into `RainRecord` values('1916','NOV','1.28',null);
insert into `RainRecord` values('1888','DEC','9.69',null);
insert into `RainRecord` values('1889','DEC','38.73',null);
insert into `RainRecord` values('1890','DEC','9.45',null);
insert into `RainRecord` values('1891','DEC','11.97',null);
insert into `RainRecord` values('1892','DEC','21.11',null);
insert into `RainRecord` values('1893','DEC','4.59',null);
insert into `RainRecord` values('1894','DEC','30.53',null);
insert into `RainRecord` values('1895','DEC','4.88',null);
insert into `RainRecord` values('1896','DEC','10.3',null);
insert into `RainRecord` values('1897','DEC','3.76',null);
insert into `RainRecord` values('1898','DEC','2.33',null);
insert into `RainRecord` values('1899','DEC','6.26',null);
insert into `RainRecord` values('1900','DEC','3.34',null);
insert into `RainRecord` values('1901','DEC','1.55',null);
insert into `RainRecord` values('1902','DEC','3.36',null);
insert into `RainRecord` values('1903','DEC','0.93',null);
insert into `RainRecord` values('1904','DEC','4.44',null);
insert into `RainRecord` values('1905','DEC','3.08',null);
insert into `RainRecord` values('1906','DEC','16.05',null);
insert into `RainRecord` values('1907','DEC','8.33',null);
insert into `RainRecord` values('1908','DEC','5.8',null);
insert into `RainRecord` values('1909','DEC','12.43',null);
insert into `RainRecord` values('1910','DEC','2.25',null);
insert into `RainRecord` values('1911','DEC','4.98',null);
insert into `RainRecord` values('1912','DEC','2.25',null);
insert into `RainRecord` values('1913','DEC','13.16',null);
insert into `RainRecord` values('1914','DEC','12.77',null);
insert into `RainRecord` values('1915','DEC','9.52',null);
insert into `RainRecord` values('1916','DEC','13.53',null);

select count(*) from RainRecord;