René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Average temprature in Edinburgh 1764-1820 for each month

set feedback off

create table scottish_weather (
  month    number(2),
  year     number(4),
  avg_temp number(4,2)
);


insert into scottish_weather values ( 1, 1764, 36.3 );
insert into scottish_weather values ( 2, 1764, 38.0 );
insert into scottish_weather values ( 3, 1764, 38.7 );
insert into scottish_weather values ( 4, 1764, 44.0 );
insert into scottish_weather values ( 5, 1764, 52.2 );
insert into scottish_weather values ( 6, 1764, 55.6 );
insert into scottish_weather values ( 7, 1764, 59.9 );
insert into scottish_weather values ( 8, 1764, 57.6 );
insert into scottish_weather values ( 9, 1764, 51.0 );
insert into scottish_weather values (10, 1764, 46.5 );
insert into scottish_weather values (11, 1764, 38.4 );
insert into scottish_weather values (12, 1764, 36.1 );
insert into scottish_weather values ( 1, 1765, 39.7 );
insert into scottish_weather values ( 2, 1765, 32.9 );
insert into scottish_weather values ( 3, 1765, 40.0 );
insert into scottish_weather values ( 4, 1765, 44.5 );
insert into scottish_weather values ( 5, 1765, 51.9 );
insert into scottish_weather values ( 6, 1765, 53.7 );
insert into scottish_weather values ( 7, 1765, 58.5 );
insert into scottish_weather values ( 8, 1765, 56.8 );
insert into scottish_weather values ( 9, 1765, 51.7 );
insert into scottish_weather values (10, 1765, 47.2 );
insert into scottish_weather values (11, 1765, 37.1 );
insert into scottish_weather values (12, 1765, 35.6 );
insert into scottish_weather values ( 1, 1766, 34.7 );
insert into scottish_weather values ( 2, 1766, 34.5 );
insert into scottish_weather values ( 3, 1766, 38.1 );
insert into scottish_weather values ( 4, 1766, 45.8 );
insert into scottish_weather values ( 5, 1766, 45.8 );
insert into scottish_weather values ( 6, 1766, 54.0 );
insert into scottish_weather values ( 7, 1766, 58.9 );
insert into scottish_weather values ( 8, 1766, 59.5 );
insert into scottish_weather values ( 9, 1766, 51.6 );
insert into scottish_weather values (10, 1766, 46.6 );
insert into scottish_weather values (11, 1766, 43.0 );
insert into scottish_weather values (12, 1766, 37.6 );
insert into scottish_weather values ( 1, 1767, 31.7 );
insert into scottish_weather values ( 2, 1767, 41.1 );
insert into scottish_weather values ( 3, 1767, 38.9 );
insert into scottish_weather values ( 4, 1767, 44.8 );
insert into scottish_weather values ( 5, 1767, 48.7 );
insert into scottish_weather values ( 6, 1767, 53.1 );
insert into scottish_weather values ( 7, 1767, 56.4 );
insert into scottish_weather values ( 8, 1767, 59.8 );
insert into scottish_weather values ( 9, 1767, 54.6 );
insert into scottish_weather values (10, 1767, 45.7 );
insert into scottish_weather values (11, 1767, 43.0 );
insert into scottish_weather values (12, 1767, 39.3 );
insert into scottish_weather values ( 1, 1768, 33.2 );
insert into scottish_weather values ( 2, 1768, 38.2 );
insert into scottish_weather values ( 3, 1768, 40.2 );
insert into scottish_weather values ( 4, 1768, 46.5 );
insert into scottish_weather values ( 5, 1768, 52.5 );
insert into scottish_weather values ( 6, 1768, 54.5 );
insert into scottish_weather values ( 7, 1768, 58.3 );
insert into scottish_weather values ( 8, 1768, 58.7 );
insert into scottish_weather values ( 9, 1768, 51.0 );
insert into scottish_weather values (10, 1768, 47.0 );
insert into scottish_weather values (11, 1768, 40.1 );
insert into scottish_weather values (12, 1768, 39.1 );
insert into scottish_weather values ( 1, 1769, 35.3 );
insert into scottish_weather values ( 2, 1769, 36.6 );
insert into scottish_weather values ( 3, 1769, 40.6 );
insert into scottish_weather values ( 4, 1769, 45.5 );
insert into scottish_weather values ( 5, 1769, 50.4 );
insert into scottish_weather values ( 6, 1769, 54.4 );
insert into scottish_weather values ( 7, 1769, 60.1 );
insert into scottish_weather values ( 8, 1769, 56.3 );
insert into scottish_weather values ( 9, 1769, 53.9 );
insert into scottish_weather values (10, 1769, 45.7 );
insert into scottish_weather values (11, 1769, 40.1 );
insert into scottish_weather values (12, 1769, 40.4 );
insert into scottish_weather values ( 1, 1770, 39.95);
insert into scottish_weather values ( 2, 1770, 41.12);
insert into scottish_weather values ( 3, 1770, 35.81);
insert into scottish_weather values ( 4, 1770, 41.54);
insert into scottish_weather values ( 5, 1770, 47.92);
insert into scottish_weather values ( 6, 1770, 53.3 );
insert into scottish_weather values ( 7, 1770, 57.1 );
insert into scottish_weather values ( 8, 1770, 58.2 );
insert into scottish_weather values ( 9, 1770, 55.1 );
insert into scottish_weather values (10, 1770, 44.40);
insert into scottish_weather values (11, 1770, 38.30);
insert into scottish_weather values (12, 1770, 37.65);
insert into scottish_weather values ( 1, 1771, 33.87);
insert into scottish_weather values ( 2, 1771, 38.21);
insert into scottish_weather values ( 3, 1771, 36.58);
insert into scottish_weather values ( 4, 1771, 41.73);
insert into scottish_weather values ( 5, 1771, 49.50);
insert into scottish_weather values ( 6, 1771, 54.3 );
insert into scottish_weather values ( 7, 1771, 57.4 );
insert into scottish_weather values ( 8, 1771, 56.3 );
insert into scottish_weather values ( 9, 1771, 51.0 );
insert into scottish_weather values (10, 1771, 47.20);
insert into scottish_weather values (11, 1771, 42.11);
insert into scottish_weather values (12, 1771, 41.70);
insert into scottish_weather values ( 1, 1772, 32.62);
insert into scottish_weather values ( 2, 1772, 32.64);
insert into scottish_weather values ( 3, 1772, 37.87);
insert into scottish_weather values ( 4, 1772, 42.71);
insert into scottish_weather values ( 5, 1772, 48.60);
insert into scottish_weather values ( 6, 1772, 56.1 );
insert into scottish_weather values ( 7, 1772, 58.0 );
insert into scottish_weather values ( 8, 1772, 57.4 );
insert into scottish_weather values ( 9, 1772, 51.0 );
insert into scottish_weather values (10, 1772, 49.00);
insert into scottish_weather values (11, 1772, 42.40);
insert into scottish_weather values (12, 1772, 39.60);
insert into scottish_weather values ( 1, 1773, 38.53);
insert into scottish_weather values ( 2, 1773, 36.23);
insert into scottish_weather values ( 3, 1773, 43.00);
insert into scottish_weather values ( 4, 1773, 45.42);
insert into scottish_weather values ( 5, 1773, 47.92);
insert into scottish_weather values ( 6, 1773, 54.0 );
insert into scottish_weather values ( 7, 1773, 56.2 );
insert into scottish_weather values ( 8, 1773, 58.3 );
insert into scottish_weather values ( 9, 1773, 51.3 );
insert into scottish_weather values (10, 1773, 46.10);
insert into scottish_weather values (11, 1773, 39.21);
insert into scottish_weather values (12, 1773, 36.53);
insert into scottish_weather values ( 1, 1774, 30.10);
insert into scottish_weather values ( 2, 1774, 36.74);
insert into scottish_weather values ( 3, 1774, 38.22);
insert into scottish_weather values ( 4, 1774, 43.60);
insert into scottish_weather values ( 5, 1774, 45.50);
insert into scottish_weather values ( 6, 1774, 54.0 );
insert into scottish_weather values ( 7, 1774, 56.8 );
insert into scottish_weather values ( 8, 1774, 56.7 );
insert into scottish_weather values ( 9, 1774, 52.1 );
insert into scottish_weather values (10, 1774, 48.70);
insert into scottish_weather values (11, 1774, 39.04);
insert into scottish_weather values (12, 1774, 37.74);
insert into scottish_weather values ( 1, 1775, 38.37);
insert into scottish_weather values ( 2, 1775, 39.93);
insert into scottish_weather values ( 3, 1775, 40.24);
insert into scottish_weather values ( 4, 1775, 47.20);
insert into scottish_weather values ( 5, 1775, 53.00);
insert into scottish_weather values ( 6, 1775, 55.1 );
insert into scottish_weather values ( 7, 1775, 59.7 );
insert into scottish_weather values ( 8, 1775, 57.5 );
insert into scottish_weather values ( 9, 1775, 53.4 );
insert into scottish_weather values (10, 1775, 45.90);
insert into scottish_weather values (11, 1775, 38.52);
insert into scottish_weather values (12, 1775, 39.10);
insert into scottish_weather values ( 1, 1776, 29.21);
insert into scottish_weather values ( 2, 1776, 36.73);
insert into scottish_weather values ( 3, 1776, 42.14);
insert into scottish_weather values ( 4, 1776, 46.52);
insert into scottish_weather values ( 5, 1776, 49.40);
insert into scottish_weather values ( 6, 1776, 54.3 );
insert into scottish_weather values ( 7, 1776, 59.6 );
insert into scottish_weather values ( 8, 1776, 56.7 );
insert into scottish_weather values ( 9, 1776, 51.5 );
insert into scottish_weather values (10, 1776, 47.80);
insert into scottish_weather values (11, 1776, 41.02);
insert into scottish_weather values (12, 1776, 38.14);
insert into scottish_weather values ( 1, 1777, 35.42);
insert into scottish_weather values ( 2, 1777, 35.28);
insert into scottish_weather values ( 3, 1777, 40.17);
insert into scottish_weather values ( 4, 1777, 42.65);
insert into scottish_weather values ( 5, 1777, 51.20);
insert into scottish_weather values ( 6, 1777, 53.7 );
insert into scottish_weather values ( 7, 1777, 57.5 );
insert into scottish_weather values ( 8, 1777, 59.2 );
insert into scottish_weather values ( 9, 1777, 55.8 );
insert into scottish_weather values (10, 1777, 48.80);
insert into scottish_weather values (11, 1777, 42.91);
insert into scottish_weather values (12, 1777, 38.84);
insert into scottish_weather values ( 1, 1778, 37.82);
insert into scottish_weather values ( 2, 1778, 39.55);
insert into scottish_weather values ( 3, 1778, 40.12);
insert into scottish_weather values ( 4, 1778, 44.00);
insert into scottish_weather values ( 5, 1778, 53.10);
insert into scottish_weather values ( 6, 1778, 59.1 );
insert into scottish_weather values ( 7, 1778, 61.2 );
insert into scottish_weather values ( 8, 1778, 58.7 );
insert into scottish_weather values ( 9, 1778, 51.3 );
insert into scottish_weather values (10, 1778, 42.60);
insert into scottish_weather values (11, 1778, 40.80);
insert into scottish_weather values (12, 1778, 43.41);
insert into scottish_weather values ( 1, 1779, 37.62);
insert into scottish_weather values ( 2, 1779, 47.20);
insert into scottish_weather values ( 3, 1779, 46.51);
insert into scottish_weather values ( 4, 1779, 47.12);
insert into scottish_weather values ( 5, 1779, 51.03);
insert into scottish_weather values ( 6, 1779, 58.1 );
insert into scottish_weather values ( 7, 1779, 65.2 );
insert into scottish_weather values ( 8, 1779, 63.7 );
insert into scottish_weather values ( 9, 1779, 56.0 );
insert into scottish_weather values (10, 1779, 48.80);
insert into scottish_weather values (11, 1779, 40.93);
insert into scottish_weather values (12, 1779, 33.15);
insert into scottish_weather values ( 1, 1780, 28.48);
insert into scottish_weather values ( 2, 1780, 35.16);
insert into scottish_weather values ( 3, 1780, 44.72);
insert into scottish_weather values ( 4, 1780, 42.05);
insert into scottish_weather values ( 5, 1780, 53.20);
insert into scottish_weather values ( 6, 1780, 57.0 );
insert into scottish_weather values ( 7, 1780, 60.7 );
insert into scottish_weather values ( 8, 1780, 63.2 );
insert into scottish_weather values ( 9, 1780, 57.4 );
insert into scottish_weather values (10, 1780, 45.90);
insert into scottish_weather values (11, 1780, 38.86);
insert into scottish_weather values (12, 1780, 39.51);
insert into scottish_weather values ( 1, 1781, 36.35);
insert into scottish_weather values ( 2, 1781, 40.30);
insert into scottish_weather values ( 3, 1781, 44.52);
insert into scottish_weather values ( 4, 1781, 47.50);
insert into scottish_weather values ( 5, 1781, 51.91);
insert into scottish_weather values ( 6, 1781, 59.8 );
insert into scottish_weather values ( 7, 1781, 60.4 );
insert into scottish_weather values ( 8, 1781, 58.6 );
insert into scottish_weather values ( 9, 1781, 52.7 );
insert into scottish_weather values (10, 1781, 48.51);
insert into scottish_weather values (11, 1781, 43.42);
insert into scottish_weather values (12, 1781, 41.11);
insert into scottish_weather values ( 1, 1782, 39.41);
insert into scottish_weather values ( 2, 1782, 34.76);
insert into scottish_weather values ( 3, 1782, 37.85);
insert into scottish_weather values ( 4, 1782, 40.73);
insert into scottish_weather values ( 5, 1782, 47.24);
insert into scottish_weather values ( 6, 1782, 57.2 );
insert into scottish_weather values ( 7, 1782, 60.1 );
insert into scottish_weather values ( 8, 1782, 56.1 );
insert into scottish_weather values ( 9, 1782, 51.4 );
insert into scottish_weather values (10, 1782, 44.03);
insert into scottish_weather values (11, 1782, 35.63);
insert into scottish_weather values (12, 1782, 35.92);
insert into scottish_weather values ( 1, 1783, 37.17);
insert into scottish_weather values ( 2, 1783, 38.96);
insert into scottish_weather values ( 3, 1783, 37.50);
insert into scottish_weather values ( 4, 1783, 48.51);
insert into scottish_weather values ( 5, 1783, 49.91);
insert into scottish_weather values ( 6, 1783, 54.2 );
insert into scottish_weather values ( 7, 1783, 63.2 );
insert into scottish_weather values ( 8, 1783, 58.4 );
insert into scottish_weather values ( 9, 1783, 53.6 );
insert into scottish_weather values (10, 1783, 47.20);
insert into scottish_weather values (11, 1783, 41.21);
insert into scottish_weather values (12, 1783, 37.16);
insert into scottish_weather values ( 1, 1784, 32.25);
insert into scottish_weather values ( 2, 1784, 34.87);
insert into scottish_weather values ( 3, 1784, 35.06);
insert into scottish_weather values ( 4, 1784, 41.12);
insert into scottish_weather values ( 5, 1784, 55.40);
insert into scottish_weather values ( 6, 1784, 53.5 );
insert into scottish_weather values ( 7, 1784, 58.5 );
insert into scottish_weather values ( 8, 1784, 56.4 );
insert into scottish_weather values ( 9, 1784, 54.7 );
insert into scottish_weather values (10, 1784, 46.41);
insert into scottish_weather values (11, 1784, 39.70);
insert into scottish_weather values (12, 1784, 34.05);
insert into scottish_weather values ( 1, 1785, 38.27);
insert into scottish_weather values ( 2, 1785, 32.89);
insert into scottish_weather values ( 3, 1785, 34.24);
insert into scottish_weather values ( 4, 1785, 49.20);
insert into scottish_weather values ( 5, 1785, 50.61);
insert into scottish_weather values ( 6, 1785, 60.7 );
insert into scottish_weather values ( 7, 1785, 58.3 );
insert into scottish_weather values ( 8, 1785, 54.1 );
insert into scottish_weather values ( 9, 1785, 54.3 );
insert into scottish_weather values (10, 1785, 45.70);
insert into scottish_weather values (11, 1785, 43.20);
insert into scottish_weather values (12, 1785, 36.15);
insert into scottish_weather values ( 1, 1786, 36.04);
insert into scottish_weather values ( 2, 1786, 37.02);
insert into scottish_weather values ( 3, 1786, 35.40);
insert into scottish_weather values ( 4, 1786, 45.11);
insert into scottish_weather values ( 5, 1786, 49.70);
insert into scottish_weather values ( 6, 1786, 57.6 );
insert into scottish_weather values ( 7, 1786, 56.4 );
insert into scottish_weather values ( 8, 1786, 58.7 );
insert into scottish_weather values ( 9, 1786, 51.1 );
insert into scottish_weather values (10, 1786, 44.00);
insert into scottish_weather values (11, 1786, 39.00);
insert into scottish_weather values (12, 1786, 36.35);
insert into scottish_weather values ( 1, 1787, 40.04);
insert into scottish_weather values ( 2, 1787, 43.80);
insert into scottish_weather values ( 3, 1787, 44.41);
insert into scottish_weather values ( 4, 1787, 43.90);
insert into scottish_weather values ( 5, 1787, 49.70);
insert into scottish_weather values ( 6, 1787, 53.8 );
insert into scottish_weather values ( 7, 1787, 60.0 );
insert into scottish_weather values ( 8, 1787, 60.0 );
insert into scottish_weather values ( 9, 1787, 53.6 );
insert into scottish_weather values (10, 1787, 48.00);
insert into scottish_weather values (11, 1787, 38.00);
insert into scottish_weather values (12, 1787, 36.88);
insert into scottish_weather values ( 1, 1788, 38.80);
insert into scottish_weather values ( 2, 1788, 37.27);
insert into scottish_weather values ( 3, 1788, 37.42);
insert into scottish_weather values ( 4, 1788, 49.21);
insert into scottish_weather values ( 5, 1788, 50.20);
insert into scottish_weather values ( 6, 1788, 57.2 );
insert into scottish_weather values ( 7, 1788, 60.3 );
insert into scottish_weather values ( 8, 1788, 58.8 );
insert into scottish_weather values ( 9, 1788, 54.4 );
insert into scottish_weather values (10, 1788, 47.80);
insert into scottish_weather values (11, 1788, 42.41);
insert into scottish_weather values (12, 1788, 32.26);
insert into scottish_weather values ( 1, 1789, 34.69);
insert into scottish_weather values ( 2, 1789, 40.22);
insert into scottish_weather values ( 3, 1789, 34.68);
insert into scottish_weather values ( 4, 1789, 43.82);
insert into scottish_weather values ( 5, 1789, 53.20);
insert into scottish_weather values ( 6, 1789, 56.9 );
insert into scottish_weather values ( 7, 1789, 60.9 );
insert into scottish_weather values ( 8, 1789, 61.6 );
insert into scottish_weather values ( 9, 1789, 55.0 );
insert into scottish_weather values (10, 1789, 47.60);
insert into scottish_weather values (11, 1789, 41.00);
insert into scottish_weather values (12, 1789, 43.90);
insert into scottish_weather values ( 1, 1790, 39.44);
insert into scottish_weather values ( 2, 1790, 44.71);
insert into scottish_weather values ( 3, 1790, 43.20);
insert into scottish_weather values ( 4, 1790, 42.64);
insert into scottish_weather values ( 5, 1790, 52.80);
insert into scottish_weather values ( 6, 1790, 58.8 );
insert into scottish_weather values ( 7, 1790, 59.0 );
insert into scottish_weather values ( 8, 1790, 57.8 );
insert into scottish_weather values ( 9, 1790, 52.8 );
insert into scottish_weather values (10, 1790, 48.80);
insert into scottish_weather values (11, 1790, 39.91);
insert into scottish_weather values (12, 1790, 37.93);
insert into scottish_weather values ( 1, 1791, 38.85);
insert into scottish_weather values ( 2, 1791, 39.30);
insert into scottish_weather values ( 3, 1791, 43.90);
insert into scottish_weather values ( 4, 1791, 47.50);
insert into scottish_weather values ( 5, 1791, 52.00);
insert into scottish_weather values ( 6, 1791, 56.9 );
insert into scottish_weather values ( 7, 1791, 58.6 );
insert into scottish_weather values ( 8, 1791, 58.4 );
insert into scottish_weather values ( 9, 1791, 54.7 );
insert into scottish_weather values (10, 1791, 46.70);
insert into scottish_weather values (11, 1791, 41.20);
insert into scottish_weather values (12, 1791, 32.75);
insert into scottish_weather values ( 1, 1792, 34.84);
insert into scottish_weather values ( 2, 1792, 39.84);
insert into scottish_weather values ( 3, 1792, 40.95);
insert into scottish_weather values ( 4, 1792, 49.80);
insert into scottish_weather values ( 5, 1792, 48.60);
insert into scottish_weather values ( 6, 1792, 53.7 );
insert into scottish_weather values ( 7, 1792, 58.4 );
insert into scottish_weather values ( 8, 1792, 60.3 );
insert into scottish_weather values ( 9, 1792, 51.0 );
insert into scottish_weather values (10, 1792, 46.20);
insert into scottish_weather values (11, 1792, 44.51);
insert into scottish_weather values (12, 1792, 37.63);
insert into scottish_weather values ( 1, 1793, 37.42);
insert into scottish_weather values ( 2, 1793, 40.11);
insert into scottish_weather values ( 3, 1793, 37.67);
insert into scottish_weather values ( 4, 1793, 40.43);
insert into scottish_weather values ( 5, 1793, 49.50);
insert into scottish_weather values ( 6, 1793, 53.9 );
insert into scottish_weather values ( 7, 1793, 60.0 );
insert into scottish_weather values ( 8, 1793, 57.8 );
insert into scottish_weather values ( 9, 1793, 52.9 );
insert into scottish_weather values (10, 1793, 51.70);
insert into scottish_weather values (11, 1793, 41.00);
insert into scottish_weather values (12, 1793, 40.60);
insert into scottish_weather values ( 1, 1794, 38.25);
insert into scottish_weather values ( 2, 1794, 43.00);
insert into scottish_weather values ( 3, 1794, 43.20);
insert into scottish_weather values ( 4, 1794, 46.80);
insert into scottish_weather values ( 5, 1794, 50.60);
insert into scottish_weather values ( 6, 1794, 58.4 );
insert into scottish_weather values ( 7, 1794, 60.7 );
insert into scottish_weather values ( 8, 1794, 56.4 );
insert into scottish_weather values ( 9, 1794, 52.2 );
insert into scottish_weather values (10, 1794, 47.00);
insert into scottish_weather values (11, 1794, 40.81);
insert into scottish_weather values (12, 1794, 40.24);
insert into scottish_weather values ( 1, 1795, 29.90);
insert into scottish_weather values ( 2, 1795, 31.64);
insert into scottish_weather values ( 3, 1795, 37.56);
insert into scottish_weather values ( 4, 1795, 45.20);
insert into scottish_weather values ( 5, 1795, 49.41);
insert into scottish_weather values ( 6, 1795, 52.9 );
insert into scottish_weather values ( 7, 1795, 57.6 );
insert into scottish_weather values ( 8, 1795, 59.3 );
insert into scottish_weather values ( 9, 1795, 57.0 );
insert into scottish_weather values (10, 1795, 50.80);
insert into scottish_weather values (11, 1795, 37.94);
insert into scottish_weather values (12, 1795, 42.90);
insert into scottish_weather values ( 1, 1796, 43.81);
insert into scottish_weather values ( 2, 1796, 40.50);
insert into scottish_weather values ( 3, 1796, 39.02);
insert into scottish_weather values ( 4, 1796, 48.90);
insert into scottish_weather values ( 5, 1796, 49.00);
insert into scottish_weather values ( 6, 1796, 55.8 );
insert into scottish_weather values ( 7, 1796, 57.6 );
insert into scottish_weather values ( 8, 1796, 59.5 );
insert into scottish_weather values ( 9, 1796, 55.1 );
insert into scottish_weather values (10, 1796, 44.80);
insert into scottish_weather values (11, 1796, 39.20);
insert into scottish_weather values (12, 1796, 31.85);
insert into scottish_weather values ( 1, 1797, 40.71);
insert into scottish_weather values ( 2, 1797, 43.81);
insert into scottish_weather values ( 3, 1797, 39.52);
insert into scottish_weather values ( 4, 1797, 44.60);
insert into scottish_weather values ( 5, 1797, 52.00);
insert into scottish_weather values ( 6, 1797, 54.4 );
insert into scottish_weather values ( 7, 1797, 60.9 );
insert into scottish_weather values ( 8, 1797, 58.0 );
insert into scottish_weather values ( 9, 1797, 53.8 );
insert into scottish_weather values (10, 1797, 44.70);
insert into scottish_weather values (11, 1797, 38.53);
insert into scottish_weather values (12, 1797, 40.02);
insert into scottish_weather values ( 1, 1798, 38.41);
insert into scottish_weather values ( 2, 1798, 38.96);
insert into scottish_weather values ( 3, 1798, 40.63);
insert into scottish_weather values ( 4, 1798, 49.80);
insert into scottish_weather values ( 5, 1798, 53.30);
insert into scottish_weather values ( 6, 1798, 60.8 );
insert into scottish_weather values ( 7, 1798, 60.6 );
insert into scottish_weather values ( 8, 1798, 59.4 );
insert into scottish_weather values ( 9, 1798, 54.9 );
insert into scottish_weather values (10, 1798, 48.20);
insert into scottish_weather values (11, 1798, 39.00);
insert into scottish_weather values (12, 1798, 35.83);
insert into scottish_weather values ( 1, 1799, 37.23);
insert into scottish_weather values ( 2, 1799, 36.23);
insert into scottish_weather values ( 3, 1799, 38.08);
insert into scottish_weather values ( 4, 1799, 41.14);
insert into scottish_weather values ( 5, 1799, 48.50);
insert into scottish_weather values ( 6, 1799, 55.4 );
insert into scottish_weather values ( 7, 1799, 58.0 );
insert into scottish_weather values ( 8, 1799, 55.9 );
insert into scottish_weather values ( 9, 1799, 54.6 );
insert into scottish_weather values (10, 1799, 45.10);
insert into scottish_weather values (11, 1799, 40.30);
insert into scottish_weather values (12, 1799, 35.15);
insert into scottish_weather values ( 1, 1800, 35.33);
insert into scottish_weather values ( 2, 1800, 36.36);
insert into scottish_weather values ( 3, 1800, 38.53);
insert into scottish_weather values ( 4, 1800, 46.90);
insert into scottish_weather values ( 5, 1800, 51.10);
insert into scottish_weather values ( 6, 1800, 55.5 );
insert into scottish_weather values ( 7, 1800, 61.6 );
insert into scottish_weather values ( 8, 1800, 59.7 );
insert into scottish_weather values ( 9, 1800, 55.1 );
insert into scottish_weather values (10, 1800, 47.70);
insert into scottish_weather values (11, 1800, 40.12);
insert into scottish_weather values (12, 1800, 36.24);
insert into scottish_weather values ( 1, 1801, 39.14);
insert into scottish_weather values ( 2, 1801, 39.97);
insert into scottish_weather values ( 3, 1801, 42.58);
insert into scottish_weather values ( 4, 1801, 46.35);
insert into scottish_weather values ( 5, 1801, 52.00);
insert into scottish_weather values ( 6, 1801, 57.4 );
insert into scottish_weather values ( 7, 1801, 58.9 );
insert into scottish_weather values ( 8, 1801, 60.4 );
insert into scottish_weather values ( 9, 1801, 56.2 );
insert into scottish_weather values (10, 1801, 49.40);
insert into scottish_weather values (11, 1801, 40.03);
insert into scottish_weather values (12, 1801, 34.08);
insert into scottish_weather values ( 1, 1802, 36.94);
insert into scottish_weather values ( 2, 1802, 37.87);
insert into scottish_weather values ( 3, 1802, 42.04);
insert into scottish_weather values ( 4, 1802, 46.62);
insert into scottish_weather values ( 5, 1802, 49.05);
insert into scottish_weather values ( 6, 1802, 55.5 );
insert into scottish_weather values ( 7, 1802, 56.3 );
insert into scottish_weather values ( 8, 1802, 60.1 );
insert into scottish_weather values ( 9, 1802, 55.1 );
insert into scottish_weather values (10, 1802, 49.60);
insert into scottish_weather values (11, 1802, 41.51);
insert into scottish_weather values (12, 1802, 37.91);
insert into scottish_weather values ( 1, 1803, 35.65);
insert into scottish_weather values ( 2, 1803, 37.75);
insert into scottish_weather values ( 3, 1803, 41.93);
insert into scottish_weather values ( 4, 1803, 46.51);
insert into scottish_weather values ( 5, 1803, 50.11);
insert into scottish_weather values ( 6, 1803, 55.6 );
insert into scottish_weather values ( 7, 1803, 62.8 );
insert into scottish_weather values ( 8, 1803, 59.1 );
insert into scottish_weather values ( 9, 1803, 52.5 );
insert into scottish_weather values (10, 1803, 47.20);
insert into scottish_weather values (11, 1803, 39.02);
insert into scottish_weather values (12, 1803, 38.57);
insert into scottish_weather values ( 1, 1804, 40.25);
insert into scottish_weather values ( 2, 1804, 36.44);
insert into scottish_weather values ( 3, 1804, 38.71);
insert into scottish_weather values ( 4, 1804, 43.06);
insert into scottish_weather values ( 5, 1804, 54.10);
insert into scottish_weather values ( 6, 1804, 59.6 );
insert into scottish_weather values ( 7, 1804, 59.1 );
insert into scottish_weather values ( 8, 1804, 58.6 );
insert into scottish_weather values ( 9, 1804, 51.1 );
insert into scottish_weather values (10, 1804, 49.40);
insert into scottish_weather values (11, 1804, 41.61);
insert into scottish_weather values (12, 1804, 36.26);
insert into scottish_weather values ( 1, 1805, 37.22);
insert into scottish_weather values ( 2, 1805, 38.94);
insert into scottish_weather values ( 3, 1805, 42.51);
insert into scottish_weather values ( 4, 1805, 46.32);
insert into scottish_weather values ( 5, 1805, 47.91);
insert into scottish_weather values ( 6, 1805, 53.8 );
insert into scottish_weather values ( 7, 1805, 59.3 );
insert into scottish_weather values ( 8, 1805, 59.4 );
insert into scottish_weather values ( 9, 1805, 56.4 );
insert into scottish_weather values (10, 1805, 46.30);
insert into scottish_weather values (11, 1805, 42.10);
insert into scottish_weather values (12, 1805, 36.74);
insert into scottish_weather values ( 1, 1806, 35.10);
insert into scottish_weather values ( 2, 1806, 36.75);
insert into scottish_weather values ( 3, 1806, 39.33);
insert into scottish_weather values ( 4, 1806, 41.53);
insert into scottish_weather values ( 5, 1806, 50.00);
insert into scottish_weather values ( 6, 1806, 56.6 );
insert into scottish_weather values ( 7, 1806, 57.5 );
insert into scottish_weather values ( 8, 1806, 58.8 );
insert into scottish_weather values ( 9, 1806, 55.5 );
insert into scottish_weather values (10, 1806, 49.50);
insert into scottish_weather values (11, 1806, 42.91);
insert into scottish_weather values (12, 1806, 39.90);
insert into scottish_weather values ( 1, 1807, 36.32);
insert into scottish_weather values ( 2, 1807, 35.76);
insert into scottish_weather values ( 3, 1807, 39.38);
insert into scottish_weather values ( 4, 1807, 44.74);
insert into scottish_weather values ( 5, 1807, 47.80);
insert into scottish_weather values ( 6, 1807, 55.1 );
insert into scottish_weather values ( 7, 1807, 61.0 );
insert into scottish_weather values ( 8, 1807, 59.8 );
insert into scottish_weather values ( 9, 1807, 48.2 );
insert into scottish_weather values (10, 1807, 50.60);
insert into scottish_weather values (11, 1807, 34.07);
insert into scottish_weather values (12, 1807, 35.12);
insert into scottish_weather values ( 1, 1808, 35.29);
insert into scottish_weather values ( 2, 1808, 35.53);
insert into scottish_weather values ( 3, 1808, 37.36);
insert into scottish_weather values ( 4, 1808, 41.67);
insert into scottish_weather values ( 5, 1808, 54.30);
insert into scottish_weather values ( 6, 1808, 56.3 );
insert into scottish_weather values ( 7, 1808, 62.5 );
insert into scottish_weather values ( 8, 1808, 60.4 );
insert into scottish_weather values ( 9, 1808, 54.1 );
insert into scottish_weather values (10, 1808, 43.61);
insert into scottish_weather values (11, 1808, 40.10);
insert into scottish_weather values (12, 1808, 35.47);
insert into scottish_weather values ( 1, 1809, 36.30);
insert into scottish_weather values ( 2, 1809, 38.77);
insert into scottish_weather values ( 3, 1809, 42.53);
insert into scottish_weather values ( 4, 1809, 40.45);
insert into scottish_weather values ( 5, 1809, 52.01);
insert into scottish_weather values ( 6, 1809, 55.1 );
insert into scottish_weather values ( 7, 1809, 57.3 );
insert into scottish_weather values ( 8, 1809, 57.4 );
insert into scottish_weather values ( 9, 1809, 52.8 );
insert into scottish_weather values (10, 1809, 51.00);
insert into scottish_weather values (11, 1809, 39.80);
insert into scottish_weather values (12, 1809, 36.64);
insert into scottish_weather values ( 1, 1810, 36.85);
insert into scottish_weather values ( 2, 1810, 36.24);
insert into scottish_weather values ( 3, 1810, 36.65);
insert into scottish_weather values ( 4, 1810, 44.50);
insert into scottish_weather values ( 5, 1810, 45.11);
insert into scottish_weather values ( 6, 1810, 55.8 );
insert into scottish_weather values ( 7, 1810, 57.2 );
insert into scottish_weather values ( 8, 1810, 58.0 );
insert into scottish_weather values ( 9, 1810, 55.8 );
insert into scottish_weather values (10, 1810, 48.40);
insert into scottish_weather values (11, 1810, 39.13);
insert into scottish_weather values (12, 1810, 35.72);
insert into scottish_weather values ( 1, 1811, 33.68);
insert into scottish_weather values ( 2, 1811, 37.74);
insert into scottish_weather values ( 3, 1811, 43.50);
insert into scottish_weather values ( 4, 1811, 43.63);
insert into scottish_weather values ( 5, 1811, 52.20);
insert into scottish_weather values ( 6, 1811, 54.8 );
insert into scottish_weather values ( 7, 1811, 59.3 );
insert into scottish_weather values ( 8, 1811, 56.7 );
insert into scottish_weather values ( 9, 1811, 54.8 );
insert into scottish_weather values (10, 1811, 51.50);
insert into scottish_weather values (11, 1811, 43.80);
insert into scottish_weather values (12, 1811, 35.95);
insert into scottish_weather values ( 1, 1812, 36.35);
insert into scottish_weather values ( 2, 1812, 39.43);
insert into scottish_weather values ( 3, 1812, 36.86);
insert into scottish_weather values ( 4, 1812, 40.74);
insert into scottish_weather values ( 5, 1812, 49.02);
insert into scottish_weather values ( 6, 1812, 55.3 );
insert into scottish_weather values ( 7, 1812, 57.0 );
insert into scottish_weather values ( 8, 1812, 57.2 );
insert into scottish_weather values ( 9, 1812, 53.3 );
insert into scottish_weather values (10, 1812, 47.30);
insert into scottish_weather values (11, 1812, 39.81);
insert into scottish_weather values (12, 1812, 34.91);
insert into scottish_weather values ( 1, 1813, 35.62);
insert into scottish_weather values ( 2, 1813, 39.72);
insert into scottish_weather values ( 3, 1813, 43.33);
insert into scottish_weather values ( 4, 1813, 44.85);
insert into scottish_weather values ( 5, 1813, 49.30);
insert into scottish_weather values ( 6, 1813, 55.9 );
insert into scottish_weather values ( 7, 1813, 59.3 );
insert into scottish_weather values ( 8, 1813, 57.5 );
insert into scottish_weather values ( 9, 1813, 53.4 );
insert into scottish_weather values (10, 1813, 44.30);
insert into scottish_weather values (11, 1813, 37.72);
insert into scottish_weather values (12, 1813, 37.31);
insert into scottish_weather values ( 1, 1814, 26.50);
insert into scottish_weather values ( 2, 1814, 35.19);
insert into scottish_weather values ( 3, 1814, 37.73);
insert into scottish_weather values ( 4, 1814, 48.20);
insert into scottish_weather values ( 5, 1814, 47.70);
insert into scottish_weather values ( 6, 1814, 52.9 );
insert into scottish_weather values ( 7, 1814, 59.4 );
insert into scottish_weather values ( 8, 1814, 57.2 );
insert into scottish_weather values ( 9, 1814, 54.4 );
insert into scottish_weather values (10, 1814, 45.40);
insert into scottish_weather values (11, 1814, 38.94);
insert into scottish_weather values (12, 1814, 36.69);
insert into scottish_weather values ( 1, 1815, 33.52);
insert into scottish_weather values ( 2, 1815, 41.60);
insert into scottish_weather values ( 3, 1815, 41.54);
insert into scottish_weather values ( 4, 1815, 45.31);
insert into scottish_weather values ( 5, 1815, 52.00);
insert into scottish_weather values ( 6, 1815, 55.9 );
insert into scottish_weather values ( 7, 1815, 58.2 );
insert into scottish_weather values ( 8, 1815, 57.8 );
insert into scottish_weather values ( 9, 1815, 53.6 );
insert into scottish_weather values (10, 1815, 47.70);
insert into scottish_weather values (11, 1815, 37.62);
insert into scottish_weather values (12, 1815, 33.87);
insert into scottish_weather values ( 1, 1816, 35.45);
insert into scottish_weather values ( 2, 1816, 35.88);
insert into scottish_weather values ( 3, 1816, 36.40);
insert into scottish_weather values ( 4, 1816, 40.96);
insert into scottish_weather values ( 5, 1816, 48.22);
insert into scottish_weather values ( 6, 1816, 53.2 );
insert into scottish_weather values ( 7, 1816, 55.7 );
insert into scottish_weather values ( 8, 1816, 55.6 );
insert into scottish_weather values ( 9, 1816, 50.9 );
insert into scottish_weather values (10, 1816, 46.30);
insert into scottish_weather values (11, 1816, 38.55);
insert into scottish_weather values (12, 1816, 35.24);
insert into scottish_weather values ( 1, 1817, 38.74);
insert into scottish_weather values ( 2, 1817, 40.33);
insert into scottish_weather values ( 3, 1817, 39.65);
insert into scottish_weather values ( 4, 1817, 44.52);
insert into scottish_weather values ( 5, 1817, 45.40);
insert into scottish_weather values ( 6, 1817, 54.7 );
insert into scottish_weather values ( 7, 1817, 57.2 );
insert into scottish_weather values ( 8, 1817, 54.1 );
insert into scottish_weather values ( 9, 1817, 53.8 );
insert into scottish_weather values (10, 1817, 42.02);
insert into scottish_weather values (11, 1817, 44.74);
insert into scottish_weather values (12, 1817, 35.66);
insert into scottish_weather values ( 1, 1818, 37.29);
insert into scottish_weather values ( 2, 1818, 35.59);
insert into scottish_weather values ( 3, 1818, 37.11);
insert into scottish_weather values ( 4, 1818, 40.85);
insert into scottish_weather values ( 5, 1818, 50.30);
insert into scottish_weather values ( 6, 1818, 58.8 );
insert into scottish_weather values ( 7, 1818, 60.0 );
insert into scottish_weather values ( 8, 1818, 56.5 );
insert into scottish_weather values ( 9, 1818, 52.9 );
insert into scottish_weather values (10, 1818, 52.40);
insert into scottish_weather values (11, 1818, 46.70);
insert into scottish_weather values (12, 1818, 38.91);
insert into scottish_weather values ( 1, 1819, 37.78);
insert into scottish_weather values ( 2, 1819, 36.47);
insert into scottish_weather values ( 3, 1819, 42.26);
insert into scottish_weather values ( 4, 1819, 45.01);
insert into scottish_weather values ( 5, 1819, 50.60);
insert into scottish_weather values ( 6, 1819, 54.8 );
insert into scottish_weather values ( 7, 1819, 59.5 );
insert into scottish_weather values ( 8, 1819, 62.7 );
insert into scottish_weather values ( 9, 1819, 53.7 );
insert into scottish_weather values (10, 1819, 46.43);
insert into scottish_weather values (11, 1819, 37.53);
insert into scottish_weather values (12, 1819, 33.39);
insert into scottish_weather values ( 1, 1820, 30.47);
insert into scottish_weather values ( 2, 1820, 40.02);
insert into scottish_weather values ( 3, 1820, 40.95);
insert into scottish_weather values ( 4, 1820, 46.91);
insert into scottish_weather values ( 5, 1820, 50.40);
insert into scottish_weather values ( 6, 1820, 55.0 );
insert into scottish_weather values ( 7, 1820, 59.0 );
insert into scottish_weather values ( 8, 1820, 56.3 );
insert into scottish_weather values ( 9, 1820, 52.2 );
insert into scottish_weather values (10, 1820, 43.90);
insert into scottish_weather values (11, 1820, 41.60);
insert into scottish_weather values (12, 1820, 39.17);