• Home

  • Documents

  • AdvancedSQL-SELECT-Abfragen - plausibolo.deplausibolo.de/ORR/Advanced-Select.pdf · Einen...
32
Advanced SQL-SELECT-Abfragen Holger Jakobs – [email protected] 2016-11-05 Inhaltsverzeichnis 1 Das SELECT-Kommando 1 2 Common Table Expressions 4 2.1 Zweck ...................................... 4 2.2 Syntax und einfache CTEs ........................... 5 2.3 Rekursive CTEs ohne Datenbankzugriff .................... 5 2.4 Rekursive CTEs zum Abfragen von Hierarchien ............... 6 2.4.1 Beispiel Mitarbeiterhierarchie ..................... 7 2.4.2 Beispiel Stückliste ............................ 9 3 OLAP mit SQL 13 3.1 Zweck ...................................... 13 3.2 Gruppierungsoperationen ............................ 14 3.3 Window Functions ............................... 17 3.4 Syntax der OVER()-Klausel ........................... 18 3.5 Verwendung von ORDER BY ........................... 18 3.6 Verwendung von PARTITION BY ........................ 20 3.7 Verwendung von ROWS und RANGE ....................... 21 3.8 Ordnungsfunktionen RANK und DENSE_RANK ................. 21 3.9 Nachbarn mit LEAD und LAG .......................... 23 3.10 Spitzenreiter und Schlusslicht mit FIRST_VALUE und LAST_VALUE ..... 25 3.11 Geburtstagsfeier ausrichten ........................... 27 3.12 Zeitreihenauswertung und Einsatz von FILTER ................ 28 3.13 Gruppeneinteilung mit NTILE ......................... 31 1 Das SELECT-Kommando Das SELECT-Kommando ist zunächst einmal ein sehr grundlegendes, denn ohne SELECT kann man bei SQL-Datenbanken überhaupt keine Daten lesen. Der Umfang und die Leis- tungsfähigkeit sind allerdings seit dem Standard SQL:1999 (oder auch SQL-99 genannt) sehr stark gewachsen. Einen Überblick über die diversen SQL-Standards gibt das Doku- ment „SQL-Standards“ vom selben Autor. Das Dokument „Die SQL-Select-Anweisung“ erläutert die Grundlagen der SQL-Abfrage gemäß der SQL-Standards vor 1999, d. h. alles, was man so im täglichen Leben als SQL-Anwender benötigt. 1

AdvancedSQL-SELECT-Abfragen - plausibolo.deplausibolo.de/ORR/Advanced-Select.pdf · Einen Überblick über die diversen SQL-Standards gibt das Doku- ... Grundsätzlich sollten sich

Embed Size (px)

Citation preview

  • Advanced SQL-SELECT-AbfragenHolger Jakobs [email protected]

    2016-11-05

    Inhaltsverzeichnis1 Das SELECT-Kommando 1

    2 Common Table Expressions 42.1 Zweck . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42.2 Syntax und einfache CTEs . . . . . . . . . . . . . . . . . . . . . . . . . . . 52.3 Rekursive CTEs ohne Datenbankzugriff . . . . . . . . . . . . . . . . . . . . 52.4 Rekursive CTEs zum Abfragen von Hierarchien . . . . . . . . . . . . . . . 6

    2.4.1 Beispiel Mitarbeiterhierarchie . . . . . . . . . . . . . . . . . . . . . 72.4.2 Beispiel Stckliste . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

    3 OLAP mit SQL 133.1 Zweck . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133.2 Gruppierungsoperationen . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143.3 Window Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173.4 Syntax der OVER()-Klausel . . . . . . . . . . . . . . . . . . . . . . . . . . . 183.5 Verwendung von ORDER BY . . . . . . . . . . . . . . . . . . . . . . . . . . . 183.6 Verwendung von PARTITION BY . . . . . . . . . . . . . . . . . . . . . . . . 203.7 Verwendung von ROWS und RANGE . . . . . . . . . . . . . . . . . . . . . . . 213.8 Ordnungsfunktionen RANK und DENSE_RANK . . . . . . . . . . . . . . . . . 213.9 Nachbarn mit LEAD und LAG . . . . . . . . . . . . . . . . . . . . . . . . . . 233.10 Spitzenreiter und Schlusslicht mit FIRST_VALUE und LAST_VALUE . . . . . 253.11 Geburtstagsfeier ausrichten . . . . . . . . . . . . . . . . . . . . . . . . . . . 273.12 Zeitreihenauswertung und Einsatz von FILTER . . . . . . . . . . . . . . . . 283.13 Gruppeneinteilung mit NTILE . . . . . . . . . . . . . . . . . . . . . . . . . 31

    1 Das SELECT-KommandoDas SELECT-Kommando ist zunchst einmal ein sehr grundlegendes, denn ohne SELECTkann man bei SQL-Datenbanken berhaupt keine Daten lesen. Der Umfang und die Leis-tungsfhigkeit sind allerdings seit dem Standard SQL:1999 (oder auch SQL-99 genannt)sehr stark gewachsen. Einen berblick ber die diversen SQL-Standards gibt das Doku-ment SQL-Standards vom selben Autor. Das Dokument Die SQL-Select-Anweisungerlutert die Grundlagen der SQL-Abfrage gem der SQL-Standards vor 1999, d. h. alles,was man so im tglichen Leben als SQL-Anwender bentigt.

    1

    mailto:[email protected]

  • Mit SQL-99 gab es zwei wesentliche Neuerungen bezglich SELECT:

    1. Common Table Expressions (CTEs1)

    2. grundlegende OLAP2-Fhigkeiten

    Diese Neuerungen werden im vorliegenden Dokument erlutert. Sie knnen in einigen Fllensehr hilfreich sein, kommen aber in der tglichen Arbeit nicht so hufig vor. Wenn sie aberangebracht sind, vereinfachen Sie die Arbeit ungeheuer und knnen auch die Performanceder Abfragen um ein Vielfaches steigern. Zudem entlasten sie die Anwendungsprogrammevon Arbeit, fr die sie nicht gut geeignet sind.

    Grundstzlich sollten sich alle Anwendungsentwickler beim Abfragen von Daten ausrelationalen Datenbanksystemen immer fragen, ob eine Verarbeitung der Daten im An-wendungsprogramm sinnvoll ist oder ob es nicht viel besser wre, die Datenbank auf eineWeise zu fragen, dass gleich die fertigen Daten an das Anwendungsprogramm geliefertwerden. In fast allen Fllen ist letzteres gnstiger. Ein Extrembeispiel wre das Abfragenaller Daten einer Tabelle, nur um beim Abholen der Tabellenzeilen einen Zhler mitlaufenzu lassen. Richtig wre es, die Datenbank die Tabellenzeilen mittels COUNT(*) zhlen unddann diese eine Zahl liefern zu lassen. Leider finden Tests oft nur mit kleinen Datenmen-gen statt, so dass beide Lsungen als quasi gleichwertig erscheinen. Sobald die Datenmengegrer wird bei einer Liste mit Lndernamen und Hauptstdten beispielsweise ist dasnicht anzunehmen, bei den Einzelverbindungsnachweisen eines Mobilfunkproviders abersehr wohl liegen zwischen beiden Anstzen mehrere Grenordnungen an Systembelas-tung bzw. Laufzeit.

    hnliche Beispiele gibt es auch bei komplexeren Abfragen, die mit dem klassischen SQLvor 1999 nicht so einfach darzustellen waren. Daher gibt es aus dieser Zeit noch viele An-wendungen, die Informationen im prozeduralen Code berechnen. Das muss man jetzt nichtunbedingt mit einem groen Knall in allen vorhandenen und zufriedenstellend laufendenAnwendungen sofort ndern, aber bei Neuentwicklungen oder bei der Suche nach Per-formanceproblemen muss man an diese Anwendungen und die zugrunde liegenden SQL-Abfragen ran und sie richtig machen.

    Der Einsatz von Advanced SQL setzt allerdings voraus, dass das verwendete Daten-banksystem diese Abfragen untersttzt. Das muss man ggf. in der Dokumentation nach-schlagen und zur Sicherheit auch ausprobieren. Datenbanksysteme, die ohnehin den Namenkaum verdienen, sind auch in diesem Bereich eher schwach aufgestellt.

    Eine SQL-Datei zum Erzeugen der Datenbank mit Mitarbeitern, Vorgesetzten und Ab-teilungen, welche u. a. fr das Beispiel in Abschnitt 2.4.1 auf Seite 7 vewendet wird, ist alsAnhang vorhanden. Bitte auf das nebenstehende Symbol klicken, um sie zu laden. Alle an-gehngten Dateien sind UTF-8-codiert und haben Newline-Zeichen als Zeilentrenner. DieTabellen sind wie untenstehend definiert. Die Inhalte sind hier nicht dokumentiert, aber inder Datei im Anhang enthalten. Der Datentyp SERIAL ist PostgreSQL-spezifisch, muss

    1https://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL#Common_table_expression2https://de.wikipedia.org/wiki/Online_Analytical_Processing

    2

    -- Personal-DB mit Vorgesetzten-Hierarchie-- 2016 [email protected], http://plausibolo.de

    DROP SCHEMA IF EXISTS bosses cascade;CREATE SCHEMA bosses;SET search_path TO bosses; -- PostgreSQL-spezifisch, muss ggf. durch ein vergleichbares Statement zum Wechseln des aktuellen Schemas ersetzt werden.

    CREATE TABLE dept ( dept_name VARCHAR(100) NOT NULL UNIQUE, budget NUMERIC(10,2) CHECK (budget > 0 OR budget IS NULL), boss INTEGER, dept_id SERIAL PRIMARY KEY);-- SERIAL ist PostgreSQL-spezifisch, muss ggf. durch eine vergleichbare Angabe zum Fllen nicht angegebener INTEGER-Werte aus einer Sequenz ersetzt werden.

    CREATE TABLE job ( job_name VARCHAR(50) NOT NULL, job_id SERIAL PRIMARY KEY);

    CREATE TABLE emp ( emp_name VARCHAR(100) NOT NULL CONSTRAINT "Name darf nicht leer sein!" CHECK (TRIM(emp_name) ''), birthdate DATE NOT NULL, job_id INTEGER NOT NULL REFERENCES job, salary NUMERIC(10,2) CONSTRAINT "Gehalt unter 1000 geht nicht" CHECK (salary > 1000 OR salary IS NULL AND job_id = 0), boss INTEGER REFERENCES emp CONSTRAINT "Niemand ist sein eigener Chef" CHECK (boss emp_id), dept_id INTEGER REFERENCES dept, emp_id SERIAL PRIMARY KEY);

    ALTER TABLE dept ADD FOREIGN KEY (boss) REFERENCES emp;

    -- JOB-BEZEICHNUNGENINSERT INTO job VALUES ('Inhaber', 0);INSERT INTO job VALUES('Verkufer'), ('Verkaufsleitung'), ('Ingenieur'), ('Techniker Entwicklung'), ('Zeichner'), ('Brofachkraft'), ('Pfrtner'), ('Archivar'), ('Maschinenbediener'), ('Einkufer'), ('Einkaufsleitung'),('Techniker Produktion'), ('Produktionsleitung'), ('Schichtleitung'), ('Geschftsfhrer'), ('Prokurist');

    -- ABTEILUNGENINSERT INTO dept VALUES ('owner', null, null),('sales', 300000, null),('development', 600000, null),('production', 400000, null);

    -- Hans ist der Inhaber des UnternehmensINSERT INTO emp VALUES ('Hans', '1970-11-11', 0, null, null, (SELECT dept_id FROM dept WHERE dept_name='owner'));

    -- ABTEILUNG SALESwith dept_nr AS (SELECT dept_id FROM dept WHERE dept_name='sales')INSERT INTO emp VALUES ('Anna', '1980-03-04', 2, 3800, null, (SELECT * FROM dept_nr)),('Udo', '1984-02-14', 1, 2700, null, (SELECT * FROM dept_nr)),('Herbert', '1989-04-24', 1, 2750, null, (SELECT * FROM dept_nr)),('Kai', '1991-12-08', 1, 2000, null, (SELECT * FROM dept_nr)),('Mara', '1973-11-26', 6, 2200, null, (SELECT * FROM dept_nr)),('Mona', '1978-05-14', 6, 2300, null, (SELECT * FROM dept_nr));

    -- Anna ist Chefin der Abteilung salesUPDATE dept SET boss=(SELECT emp_id FROM emp WHERE emp_name='Anna') WHERE dept_id=(SELECT dept_id FROM dept WHERE dept_name='sales');-- Anna ist die Vorgesetzte der Mitarbeiter ihrer AbteilungUPDATE emp SET boss=( SELECT emp_id FROM emp WHERE emp_name='Anna')WHERE emp_id IN ( SELECT emp_id FROM emp WHERE dept_id=( SELECT dept_id FROM dept WHERE dept_name='sales') AND emp_name'Anna');

    -- ABTEILUNG DEVELOPMENTWITH dept_nr AS (SELECT dept_id FROM dept WHERE dept_name='development')INSERT INTO emp VALUES ('Urs', '1973-09-23', 3, 3800, null, (SELECT * FROM dept_nr)),('Uta', '1978-09-17', 4, 2600, null, (SELECT * FROM dept_nr)),('Ulli', '1991-06-18', 4, 2100, null, (SELECT * FROM dept_nr)),('Ulf', '1998-02-28', 5, 2000, null, (SELECT * FROM dept_nr)),('Uwe', '1994-03-25', 5, 2600, null, (SELECT * FROM dept_nr)),('Ulani', '1984-12-08', 6, 2200, null, (SELECT * FROM dept_nr));

    -- Urs ist Chef der Abteilung developmentUPDATE dept SET boss=(SELECT emp_id FROM emp WHERE emp_name='Urs')WHERE dept_id IN (SELECT dept_id FROM dept WHERE dept_name='development');-- Urs ist der Vorgesetzte der Mitarbeiter seiner AbteilungUPDATE emp SET boss=( SELECT emp_id FROM emp WHERE emp_name='Urs')WHERE emp_id IN ( SELECT emp_id FROM emp WHERE dept_id=( SELECT dept_id FROM dept WHERE dept_name='development') AND emp_name'Urs');

    -- ABTEILUNG PRODUCTIONWITH dept_nr AS (SELECT dept_id FROM dept WHERE dept_name='production')INSERT INTO emp VALUES ('Peter', '1977-12-02', 13, 3500, null, (SELECT * FROM dept_nr)),('Petra', '1979-02-27', 12, 2500, null, (SELECT * FROM dept_nr)),('Paul', '1992-04-13', 12, 2400, null, (SELECT * FROM dept_nr)),('Pepe', '1985-05-03', 12, 2300, null, (SELECT * FROM dept_nr)),('Patrick', '1981-01-17', 12, 2200, null, (SELECT * FROM dept_nr)),('Pam', '1994-11-05', 14, 2400, null, (SELECT * FROM dept_nr)),('Patti', '1997-10-12', 14, 2600, null, (SELECT * FROM dept_nr)),('Paola', '1982-02-13', 6, 2200, null, (SELECT * FROM dept_nr));

    -- Peter ist Chef der Abteilung productionUPDATE dept SET boss=(SELECT emp_id FROM emp WHERE emp_name='Peter')WHERE dept_id IN (SELECT dept_id FROM dept WHERE dept_name='production');-- Peter ist der Vorgesetzte der Mitarbeiter seiner AbteilungUPDATE emp SET boss=( SELECT emp_id FROM emp WHERE emp_name='Peter')WHERE emp_id IN ( SELECT emp_id FROM emp WHERE dept_id=( SELECT dept_id FROM dept WHERE dept_name='production') AND emp_name'Peter');

    -- Hans ist Vorgesetzter der AbteilungsleiterUPDATE emp SET boss=(SELECT emp_id FROM emp WHERE emp_name='Hans')WHERE boss IS NULL AND emp_id (SELECT emp_id FROM emp WHERE emp_name='Hans');

    https://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL#Common_table_expressionhttps://de.wikipedia.org/wiki/Online_Analytical_Processing

  • ggf. durch eine vergleichbare Angabe zum Fllen nicht angegebener INTEGER-Werte auseiner Sequenz oder einen anderen auto-increment-Mechanismus ersetzt werden.

    CREATE TABLE dept (dept_name VARCHAR(100) NOT NULL UNIQUE,budget NUMERIC(10,2)CHECK (budget > 0 OR budget IS NULL),

    boss INTEGER,dept_id SERIAL PRIMARY KEY

    );

    CREATE TABLE job (job_name VARCHAR(50) NOT NULL,job_id SERIAL PRIMARY KEY

    );

    CREATE TABLE emp (emp_name VARCHAR(100) NOT NULLCONSTRAINT "Name darf nicht leer sein!" CHECK (TRIM(emp_name) ''),

    birthdate DATE NOT NULL,job_id INTEGER NOT NULL REFERENCES job,salary NUMERIC(10,2)CHECK (salary > 1000 OR salary IS NULL AND job_id = 0),

    boss INTEGER REFERENCES empCHECK (boss emp_id),

    dept_id INTEGER REFERENCES dept,emp_id SERIAL PRIMARY KEY

    );

    Fr das Stcklistenbeispiel in Abschnitt 2.4.2 auf Seite 9 gibt es einen Anhang. Die Tabellensind wie untenstehend definiert. Die Inhalte sind hier nicht dokumentiert, aber in der Dateiim Anhang enthalten.

    CREATE TABLE part (partno SERIAL PRIMARY KEY,descr VARCHAR(30) NOT NULL UNIQUE

    );

    CREATE TABLE sub_part (partno INTEGER REFERENCES part,subpartno INTEGER REFERENCES part,quantity INTEGER CHECK (quantity > 0),PRIMARY KEY (partno, subpartno)

    );

    3

    DROP SCHEMA IF EXISTS parts CASCADE;CREATE SCHEMA parts;SET search_path TO parts;

    CREATE TABLE part ( partno SERIAL PRIMARY KEY, descr VARCHAR(30) NOT NULL UNIQUE);

    CREATE TABLE sub_part ( partno INTEGER REFERENCES part, subpartno INTEGER REFERENCES part, quantity INTEGER CHECK (quantity > 0), PRIMARY KEY (partno, subpartno));

    INSERT INTO part (descr) VALUES('Tisch'), --1('Stuhl'), --2('Tischplatte'), --3('Tischbein'), --4('Schraube'), --5('Sitz'), --6('Lehne'), --7('Stuhlbein'), --8('Lehnenhalter'), --9('Sitzgruppe'), --10('Tischbeinrohr'), --11('Tischbeinkappe'),--12('Stuhlbeinrohr'), --13('Stuhlbeinkappe'), --14('Tennisschlger'), --15('Rahmen'), --16('Sehne'), --17('Griffband'); --18

    INSERT INTO sub_part VALUES-- Tennisschlger(15, 16, 1),(15, 17, 2),(15, 18, 1),-- Sitzgruppe mit Tisch und 4 Sthlen(1, 3, 1),(1, 4, 4),(1, 5, 16),(2, 8, 4),(2, 5, 20), -- 4 Beine mit je 3 Schrauben + Sitz und Lehne mit je 4(2, 6, 1),(2, 7, 1),(2, 9, 2),(10, 1, 1),(10, 2, 4),(4, 11, 1),(4, 12, 1),(8, 13, 1),(8, 14, 1);-----------------------------------------------------------

  • Eine weitere SQL-Datei zum Erzeugen der Tabelle mit den Temperaturdaten fr das Bei-spiel zur Zeitreihenanalyse in Abschnitt 3.12 auf Seite 28 ist ebenfalls als Anhang vorhan-den. Es handelt sich nur um eine Tabelle der folgenden Struktur.

    CREATE TABLE gltemps (zeit TIMESTAMP PRIMARY KEY,temp_c REAL

    );

    2 Common Table Expressions

    2.1 ZweckDer Zweck von Common Table Expressions ist zunchst einmal die Vereinfachung von Ab-fragen, indem komplexe Abfragen in mehrere einfachere Teile zerlegt werden. Ein Beispielhierfr ist:

    WITH regionUmsatz AS (SELECT region, sum(betrag) AS betragSummeFROM v_auftragGROUP BY region),

    topRegion AS (SELECT regionFROM regionUmsatzWHERE betragSumme > (SELECT SUM(betragSumme)/10 FROM regionUmsatz))

    SELECT region, produkt, SUM(anzahl) as anzahl, SUM(betrag) AS betragSummeFROM v_auftragWHERE region IN (SELECT region FROM topRegion)GROUP BY region, produkt;

    Was soll diese Abfrage ermitteln? Es geht darum, alle Auftrge aus den Top-Regionenaufzulisten, d. h. den Regionen, die zu mehr als 10 % zum Gesamtumsatz beitragen. Hierzuwerden zunchst alle Auftrge pro Region aufsummiert mit der Abfrage der ersten CTE:

    SELECT region, sum(betrag) AS betragSummeFROM v_auftragGROUP BY region;

    Das Ergebnis steht durch die CTE unter dem Namen regionUmsatz zur Verfgung undwird in der zweiten CTE eingesetzt.

    WITH regionUmsatz AS (SELECT region, sum(betrag) AS betragSummeFROM v_auftrag

    4

    -- TABELLE mit allen Einzelwerten (stundenweise)CREATE TABLE gltemps ( zeit TIMESTAMP PRIMARY KEY, temp_c REAL);

    INSERT INTO gltemps VALUES ('2007-01-19 11:06:00', 11);INSERT INTO gltemps VALUES ('2007-01-19 12:00:00', 11);INSERT INTO gltemps VALUES ('2007-01-19 13:00:00', 11);INSERT INTO gltemps VALUES ('2007-01-19 14:00:00', 12);INSERT INTO gltemps VALUES ('2007-01-19 15:00:00', 12);INSERT INTO gltemps VALUES ('2007-01-19 16:00:00', 11.8000002);INSERT INTO gltemps VALUES ('2007-01-19 17:00:00', 11);INSERT INTO gltemps VALUES ('2007-01-19 18:00:00', 10.6000004);INSERT INTO gltemps VALUES ('2007-01-19 19:00:00', 10);INSERT INTO gltemps VALUES ('2007-01-19 20:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-01-19 21:00:00', 8.19999981);INSERT INTO gltemps VALUES ('2007-01-19 22:00:00', 8.39999962);INSERT INTO gltemps VALUES ('2007-01-19 23:00:00', 10);INSERT INTO gltemps VALUES ('2007-01-20 00:00:00', 11);INSERT INTO gltemps VALUES ('2007-01-20 01:00:00', 11);INSERT INTO gltemps VALUES ('2007-01-20 02:00:00', 11);INSERT INTO gltemps VALUES ('2007-01-20 03:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 04:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 05:00:00', 12.1000004);INSERT INTO gltemps VALUES ('2007-01-20 06:00:00', 14);INSERT INTO gltemps VALUES ('2007-01-20 07:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 08:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 09:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 10:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 11:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 12:00:00', 12.6999998);INSERT INTO gltemps VALUES ('2007-01-20 13:00:00', 14);INSERT INTO gltemps VALUES ('2007-01-20 14:00:00', 14);INSERT INTO gltemps VALUES ('2007-01-20 15:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 16:00:00', 13);INSERT INTO gltemps VALUES ('2007-01-20 17:00:00', 10.5);INSERT INTO gltemps VALUES ('2007-01-20 18:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-20 19:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-20 20:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-20 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-20 22:00:00', 8.19999981);INSERT INTO gltemps VALUES ('2007-01-20 23:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 00:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 01:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-21 02:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-21 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-21 04:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-21 05:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-21 06:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-21 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-21 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-21 09:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-21 11:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-21 12:00:00', 6.5);INSERT INTO gltemps VALUES ('2007-01-21 13:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 14:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 15:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 16:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-21 17:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 18:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-21 19:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-21 20:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-21 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-21 22:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-21 23:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 00:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-22 01:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 02:00:00', 2.79999995);INSERT INTO gltemps VALUES ('2007-01-22 03:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 04:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 05:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-22 06:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-22 07:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-22 08:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-22 09:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-22 10:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-22 11:00:00', 3.0999999);INSERT INTO gltemps VALUES ('2007-01-22 12:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 13:00:00', 4.19999981);INSERT INTO gltemps VALUES ('2007-01-22 14:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 15:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 16:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 17:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-22 18:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-22 19:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-22 20:00:00', 2.5999999);INSERT INTO gltemps VALUES ('2007-01-22 21:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-22 22:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-23 14:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-23 15:00:00', 0.600000024);INSERT INTO gltemps VALUES ('2007-01-23 16:00:00', 1.29999995);INSERT INTO gltemps VALUES ('2007-01-23 17:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-24 14:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-24 15:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-24 16:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-24 17:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-24 18:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-24 21:00:00', -4);INSERT INTO gltemps VALUES ('2007-01-24 22:00:00', -4);INSERT INTO gltemps VALUES ('2007-01-24 23:00:00', -5);INSERT INTO gltemps VALUES ('2007-01-25 00:00:00', -6);INSERT INTO gltemps VALUES ('2007-01-25 01:00:00', -7);INSERT INTO gltemps VALUES ('2007-01-25 02:00:00', -6);INSERT INTO gltemps VALUES ('2007-01-25 03:00:00', -6);INSERT INTO gltemps VALUES ('2007-01-25 04:00:00', -6);INSERT INTO gltemps VALUES ('2007-01-25 05:00:00', -5);INSERT INTO gltemps VALUES ('2007-01-25 06:00:00', -5);INSERT INTO gltemps VALUES ('2007-01-25 07:00:00', -4);INSERT INTO gltemps VALUES ('2007-01-25 08:00:00', -4);INSERT INTO gltemps VALUES ('2007-01-25 09:00:00', -4);INSERT INTO gltemps VALUES ('2007-01-25 10:00:00', -3);INSERT INTO gltemps VALUES ('2007-01-25 11:00:00', -2.5999999);INSERT INTO gltemps VALUES ('2007-01-25 12:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-25 13:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-25 14:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-25 15:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-25 16:00:00', -1);INSERT INTO gltemps VALUES ('2007-01-25 17:00:00', -0.899999976);INSERT INTO gltemps VALUES ('2007-01-25 18:00:00', -3);INSERT INTO gltemps VALUES ('2007-01-25 19:00:00', -4);INSERT INTO gltemps VALUES ('2007-01-25 20:00:00', -3.9000001);INSERT INTO gltemps VALUES ('2007-01-25 21:00:00', -5);INSERT INTO gltemps VALUES ('2007-01-25 22:00:00', -6);INSERT INTO gltemps VALUES ('2007-01-25 23:00:00', -7);INSERT INTO gltemps VALUES ('2007-01-26 00:00:00', -7);INSERT INTO gltemps VALUES ('2007-01-26 01:00:00', -8);INSERT INTO gltemps VALUES ('2007-01-26 02:00:00', -9);INSERT INTO gltemps VALUES ('2007-01-26 03:00:00', -7);INSERT INTO gltemps VALUES ('2007-01-26 04:00:00', -7);INSERT INTO gltemps VALUES ('2007-01-26 05:00:00', -7);INSERT INTO gltemps VALUES ('2007-01-26 06:00:00', -6);INSERT INTO gltemps VALUES ('2007-01-26 07:00:00', -6.5);INSERT INTO gltemps VALUES ('2007-01-26 08:00:00', -6);INSERT INTO gltemps VALUES ('2007-01-26 09:00:00', -5);INSERT INTO gltemps VALUES ('2007-01-26 10:00:00', -5);INSERT INTO gltemps VALUES ('2007-01-26 11:00:00', -4);INSERT INTO gltemps VALUES ('2007-01-26 12:00:00', -3.4000001);INSERT INTO gltemps VALUES ('2007-01-26 13:00:00', -1);INSERT INTO gltemps VALUES ('2007-01-26 14:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-26 15:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-26 16:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-26 17:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-26 18:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-26 19:00:00', 0);INSERT INTO gltemps VALUES ('2007-01-26 20:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-26 21:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-26 22:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-26 23:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 00:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 01:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 02:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-27 03:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-27 04:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-27 05:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 06:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 07:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 08:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 09:00:00', 1);INSERT INTO gltemps VALUES ('2007-01-27 10:00:00', 2);INSERT INTO gltemps VALUES ('2007-01-27 11:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-27 12:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-27 13:00:00', 3.9000001);INSERT INTO gltemps VALUES ('2007-01-27 14:00:00', 4.30000019);INSERT INTO gltemps VALUES ('2007-01-27 15:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-27 16:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-27 17:00:00', 4.80000019);INSERT INTO gltemps VALUES ('2007-01-27 18:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-27 19:00:00', 3.29999995);INSERT INTO gltemps VALUES ('2007-01-27 20:00:00', 3.20000005);INSERT INTO gltemps VALUES ('2007-01-27 21:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-27 22:00:00', 3);INSERT INTO gltemps VALUES ('2007-01-27 23:00:00', 3.20000005);INSERT INTO gltemps VALUES ('2007-01-28 00:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-28 01:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-28 02:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-28 03:00:00', 4);INSERT INTO gltemps VALUES ('2007-01-28 04:00:00', 4.30000019);INSERT INTO gltemps VALUES ('2007-01-28 05:00:00', 4.5999999);INSERT INTO gltemps VALUES ('2007-01-28 06:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 07:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 08:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 09:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 10:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-01-28 11:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 12:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 13:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 14:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 15:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 16:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 17:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 18:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-28 19:00:00', 4.5999999);INSERT INTO gltemps VALUES ('2007-01-28 20:00:00', 4.5999999);INSERT INTO gltemps VALUES ('2007-01-28 21:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-01-28 22:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-01-28 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-29 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-29 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-29 02:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-29 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-29 04:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-29 05:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-29 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-29 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-29 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-29 09:00:00', 7.0999999);INSERT INTO gltemps VALUES ('2007-01-29 10:00:00', 7.19999981);INSERT INTO gltemps VALUES ('2007-01-29 11:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-29 12:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-29 13:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-29 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-29 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-29 16:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-29 17:00:00', 8.19999981);INSERT INTO gltemps VALUES ('2007-01-29 18:00:00', 8.39999962);INSERT INTO gltemps VALUES ('2007-01-29 19:00:00', 7.5);INSERT INTO gltemps VALUES ('2007-01-29 20:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-29 21:00:00', 6.30000019);INSERT INTO gltemps VALUES ('2007-01-29 22:00:00', 6.5);INSERT INTO gltemps VALUES ('2007-01-29 23:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-30 00:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-30 01:00:00', 6.0999999);INSERT INTO gltemps VALUES ('2007-01-30 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-30 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-30 04:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-30 05:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-30 06:00:00', 5);INSERT INTO gltemps VALUES ('2007-01-30 07:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-30 08:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-30 09:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-30 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-30 11:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-30 12:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-30 13:00:00', 8.60000038);INSERT INTO gltemps VALUES ('2007-01-30 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-30 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-30 16:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-30 17:00:00', 9.10000038);INSERT INTO gltemps VALUES ('2007-01-30 18:00:00', 8.60000038);INSERT INTO gltemps VALUES ('2007-01-30 20:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-30 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-30 22:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-30 23:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-31 01:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-31 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-01-31 04:00:00', 6.5);INSERT INTO gltemps VALUES ('2007-01-31 05:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 09:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 12:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-31 13:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-31 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-31 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-31 16:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-31 17:00:00', 9);INSERT INTO gltemps VALUES ('2007-01-31 18:00:00', 8);INSERT INTO gltemps VALUES ('2007-01-31 19:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 20:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 21:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 22:00:00', 7);INSERT INTO gltemps VALUES ('2007-01-31 23:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-01 00:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-01 01:00:00', 5.4000001);INSERT INTO gltemps VALUES ('2007-02-01 02:00:00', 5.69999981);INSERT INTO gltemps VALUES ('2007-02-01 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-01 04:00:00', 6.19999981);INSERT INTO gltemps VALUES ('2007-02-01 05:00:00', 6.4000001);INSERT INTO gltemps VALUES ('2007-02-01 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-01 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-01 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-01 09:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-01 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-01 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-01 12:00:00', 7.4000001);INSERT INTO gltemps VALUES ('2007-02-01 13:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-01 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-01 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-01 16:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-01 17:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-01 18:00:00', 8.69999981);INSERT INTO gltemps VALUES ('2007-02-01 19:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-01 20:00:00', 7.80000019);INSERT INTO gltemps VALUES ('2007-02-01 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-01 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-01 23:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 00:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 01:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 02:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 03:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 04:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 05:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 06:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 07:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-02-02 08:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-02 09:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-02 12:00:00', 8.19999981);INSERT INTO gltemps VALUES ('2007-02-02 13:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 16:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 17:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 18:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 19:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 20:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-02 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-02 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-02 23:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-03 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 04:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-02-03 05:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-03 06:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-03 07:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-03 08:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-03 09:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-03 10:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-03 11:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-03 12:00:00', 5.19999981);INSERT INTO gltemps VALUES ('2007-02-03 13:00:00', 5.69999981);INSERT INTO gltemps VALUES ('2007-02-03 14:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 15:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-03 16:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-03 17:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-03 18:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 19:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 20:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-03 22:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-03 23:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-04 00:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-04 01:00:00', 3.29999995);INSERT INTO gltemps VALUES ('2007-02-04 02:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-04 03:00:00', 2.29999995);INSERT INTO gltemps VALUES ('2007-02-04 04:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-04 05:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-04 06:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-04 07:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-04 08:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-04 09:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-04 10:00:00', 3.79999995);INSERT INTO gltemps VALUES ('2007-02-04 11:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-04 12:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-04 13:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-04 14:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-04 15:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-04 16:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-04 17:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-04 18:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-04 19:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-04 20:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-04 21:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-04 22:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-04 23:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 00:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-05 01:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-05 02:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-05 03:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-05 04:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-05 05:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-05 06:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-05 07:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-05 08:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-05 09:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-05 10:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-05 11:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-05 12:00:00', 2.70000005);INSERT INTO gltemps VALUES ('2007-02-05 13:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-05 14:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-05 15:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 16:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 17:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 18:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 19:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 20:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 21:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 22:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-05 23:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 00:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 01:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 02:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 03:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 04:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-06 05:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-06 06:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-06 07:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-06 08:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-06 09:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-06 10:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-06 11:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-06 12:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 13:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 14:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-06 15:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-06 16:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-06 17:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-06 18:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-06 19:00:00', 1.70000005);INSERT INTO gltemps VALUES ('2007-02-06 20:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-06 21:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-06 22:00:00', 1.29999995);INSERT INTO gltemps VALUES ('2007-02-06 23:00:00', 1.20000005);INSERT INTO gltemps VALUES ('2007-02-07 00:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-07 01:00:00', 0.400000006);INSERT INTO gltemps VALUES ('2007-02-07 02:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-07 03:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 04:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 05:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-07 06:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-07 07:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-07 08:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-07 09:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 10:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 11:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 12:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 13:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 14:00:00', 1.29999995);INSERT INTO gltemps VALUES ('2007-02-07 15:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-07 16:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-07 17:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 18:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 19:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-07 20:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-07 21:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-07 22:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-07 23:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-08 00:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-08 01:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-08 02:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-08 03:00:00', -0.699999988);INSERT INTO gltemps VALUES ('2007-02-08 04:00:00', -0.800000012);INSERT INTO gltemps VALUES ('2007-02-08 05:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-08 06:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-08 07:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-08 08:00:00', -1);INSERT INTO gltemps VALUES ('2007-02-08 09:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-08 10:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-08 11:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-08 12:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-08 13:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-08 14:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-08 15:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-08 16:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-08 17:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-08 18:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-08 19:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-08 20:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-08 21:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-08 22:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-08 23:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-09 00:00:00', 4.5999999);INSERT INTO gltemps VALUES ('2007-02-09 01:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 02:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 03:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 04:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-02-09 05:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-02-09 06:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-09 07:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 08:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 09:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 10:00:00', 4.5999999);INSERT INTO gltemps VALUES ('2007-02-09 11:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 12:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 13:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 14:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 15:00:00', 5.4000001);INSERT INTO gltemps VALUES ('2007-02-09 16:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-09 17:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-09 18:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-02-09 19:00:00', 3.9000001);INSERT INTO gltemps VALUES ('2007-02-09 20:00:00', 2.0999999);INSERT INTO gltemps VALUES ('2007-02-09 21:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-09 22:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-09 23:07:00', 2.29999995);INSERT INTO gltemps VALUES ('2007-02-10 00:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 01:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 02:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 03:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 04:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 05:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 06:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 07:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 08:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-10 09:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-10 10:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-10 11:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-10 12:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-10 13:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-10 14:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-10 15:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-10 16:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-10 17:00:00', 7.69999981);INSERT INTO gltemps VALUES ('2007-02-10 18:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-10 19:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-10 20:00:00', 6.4000001);INSERT INTO gltemps VALUES ('2007-02-10 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-10 22:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-10 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-11 00:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 01:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 02:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 03:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 04:00:00', 7.0999999);INSERT INTO gltemps VALUES ('2007-02-11 05:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 07:00:00', 7.19999981);INSERT INTO gltemps VALUES ('2007-02-11 08:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-11 09:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-11 10:00:00', 8.10000038);INSERT INTO gltemps VALUES ('2007-02-11 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 12:00:00', 7.0999999);INSERT INTO gltemps VALUES ('2007-02-11 13:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-11 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-11 15:00:00', 9.30000019);INSERT INTO gltemps VALUES ('2007-02-11 16:00:00', 11.1000004);INSERT INTO gltemps VALUES ('2007-02-11 17:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-11 18:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-11 19:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-11 20:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-11 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-11 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-11 23:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-12 00:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-12 01:00:00', 7.80000019);INSERT INTO gltemps VALUES ('2007-02-12 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-12 03:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 04:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 05:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 09:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 12:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-12 13:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-12 14:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-12 15:00:00', 10.3000002);INSERT INTO gltemps VALUES ('2007-02-12 16:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-12 17:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-12 18:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-12 19:00:00', 8.89999962);INSERT INTO gltemps VALUES ('2007-02-12 20:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-12 21:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-12 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-12 23:00:00', 7.5);INSERT INTO gltemps VALUES ('2007-02-13 00:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 01:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 02:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-13 04:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 05:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 09:00:00', 7.4000001);INSERT INTO gltemps VALUES ('2007-02-13 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 11:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 12:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 13:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-13 14:00:00', 8.39999962);INSERT INTO gltemps VALUES ('2007-02-13 15:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 16:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 17:00:00', 7.5);INSERT INTO gltemps VALUES ('2007-02-13 18:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 19:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 20:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-13 21:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 22:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-13 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 02:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-14 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 04:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-14 05:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-14 06:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 07:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 08:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 09:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 10:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 11:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 12:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-14 13:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 14:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 15:00:00', 5.4000001);INSERT INTO gltemps VALUES ('2007-02-14 16:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 17:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 18:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 19:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 20:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-14 22:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-14 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 04:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 05:00:00', 6.4000001);INSERT INTO gltemps VALUES ('2007-02-15 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-15 07:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 08:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 09:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 10:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-15 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-15 12:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-15 13:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-15 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-15 15:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-15 16:00:00', 10.6999998);INSERT INTO gltemps VALUES ('2007-02-15 17:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-15 18:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-15 19:00:00', 8.10000038);INSERT INTO gltemps VALUES ('2007-02-15 20:00:00', 6.0999999);INSERT INTO gltemps VALUES ('2007-02-15 21:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-02-15 22:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-15 23:00:00', 4.4000001);INSERT INTO gltemps VALUES ('2007-02-16 00:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-16 01:00:00', 3.79999995);INSERT INTO gltemps VALUES ('2007-02-16 02:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-16 03:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-16 04:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-16 05:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-16 06:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-16 07:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-16 08:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-16 09:00:00', 3.79999995);INSERT INTO gltemps VALUES ('2007-02-16 10:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-16 11:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-16 12:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-16 13:00:00', 8.69999981);INSERT INTO gltemps VALUES ('2007-02-16 14:00:00', 9.80000019);INSERT INTO gltemps VALUES ('2007-02-16 15:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-16 16:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-16 17:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-16 18:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-16 19:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-16 20:00:00', 8.19999981);INSERT INTO gltemps VALUES ('2007-02-16 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-16 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-16 23:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-17 00:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-17 01:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-17 02:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-17 03:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-17 04:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-17 05:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-17 06:00:00', 5.5999999);INSERT INTO gltemps VALUES ('2007-02-17 07:00:00', 5.5);INSERT INTO gltemps VALUES ('2007-02-17 08:00:00', 5.4000001);INSERT INTO gltemps VALUES ('2007-02-17 09:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-17 10:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-17 11:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-17 12:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-17 13:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-17 14:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-17 15:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-17 16:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-17 17:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-17 18:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-17 19:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-17 20:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-17 21:00:00', 7.9000001);INSERT INTO gltemps VALUES ('2007-02-17 22:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-17 23:00:00', 6.19999981);INSERT INTO gltemps VALUES ('2007-02-18 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-18 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-18 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-18 03:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-18 04:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-18 05:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-18 06:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-18 07:00:00', 1);INSERT INTO gltemps VALUES ('2007-02-18 08:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-18 09:00:00', 0);INSERT INTO gltemps VALUES ('2007-02-18 10:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-18 11:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-18 12:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-18 13:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-18 14:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-18 15:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-18 16:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-18 17:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-18 18:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-18 19:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-18 20:00:00', 4.9000001);INSERT INTO gltemps VALUES ('2007-02-18 21:00:00', 4.5999999);INSERT INTO gltemps VALUES ('2007-02-18 22:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-18 23:00:00', 4.5);INSERT INTO gltemps VALUES ('2007-02-19 00:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 01:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 02:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 03:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 04:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 05:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 06:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 07:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 08:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 09:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 10:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-19 11:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-19 12:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-19 13:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-02-19 14:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-19 15:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-19 16:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-19 17:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-19 18:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-19 19:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-19 20:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-19 21:00:00', 5.19999981);INSERT INTO gltemps VALUES ('2007-02-19 22:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-02-19 23:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-20 00:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-20 01:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-20 02:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-20 03:00:00', 2);INSERT INTO gltemps VALUES ('2007-02-20 04:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-20 05:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-20 06:00:00', 3.20000005);INSERT INTO gltemps VALUES ('2007-02-20 07:00:00', 3);INSERT INTO gltemps VALUES ('2007-02-20 08:00:00', 2.79999995);INSERT INTO gltemps VALUES ('2007-02-20 09:00:00', 3.20000005);INSERT INTO gltemps VALUES ('2007-02-20 10:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-20 11:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-20 12:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-20 13:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-20 14:00:00', 8.89999962);INSERT INTO gltemps VALUES ('2007-02-20 15:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-20 16:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-20 17:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-20 18:00:00', 12);INSERT INTO gltemps VALUES ('2007-02-20 19:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-20 20:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-20 21:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-20 22:00:00', 8.19999981);INSERT INTO gltemps VALUES ('2007-02-20 23:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-21 00:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-21 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-21 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-21 03:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-21 04:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-21 05:00:00', 4.5);INSERT INTO gltemps VALUES ('2007-02-21 06:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-21 07:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-21 08:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-21 09:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-21 10:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-21 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-21 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-21 13:00:00', 11.6999998);INSERT INTO gltemps VALUES ('2007-02-21 14:00:00', 13.6000004);INSERT INTO gltemps VALUES ('2007-02-21 15:00:00', 14);INSERT INTO gltemps VALUES ('2007-02-21 16:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-21 17:00:00', 12);INSERT INTO gltemps VALUES ('2007-02-21 18:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-21 19:00:00', 8.89999962);INSERT INTO gltemps VALUES ('2007-02-21 20:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-21 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-21 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-21 23:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-22 00:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-22 01:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-22 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-22 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-22 04:00:00', 6.4000001);INSERT INTO gltemps VALUES ('2007-02-22 05:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-22 06:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-22 07:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-22 08:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-22 09:00:00', 4);INSERT INTO gltemps VALUES ('2007-02-22 10:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-22 11:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-22 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-22 13:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-22 14:00:00', 12);INSERT INTO gltemps VALUES ('2007-02-22 15:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-22 16:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-22 17:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-22 18:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-22 19:00:00', 9.69999981);INSERT INTO gltemps VALUES ('2007-02-22 20:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-22 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-22 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-22 23:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 00:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 01:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 02:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 03:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 04:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 05:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-23 07:00:00', 6.9000001);INSERT INTO gltemps VALUES ('2007-02-23 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-23 09:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-23 10:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-23 11:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-23 12:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-23 13:00:00', 12);INSERT INTO gltemps VALUES ('2007-02-23 14:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-23 15:00:00', 12.8999996);INSERT INTO gltemps VALUES ('2007-02-23 16:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-23 17:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-23 18:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-23 19:00:00', 12);INSERT INTO gltemps VALUES ('2007-02-23 20:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-23 21:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-23 22:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-23 23:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 00:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 01:00:00', 9.5);INSERT INTO gltemps VALUES ('2007-02-24 02:00:00', 9.5);INSERT INTO gltemps VALUES ('2007-02-24 03:00:00', 9.69999981);INSERT INTO gltemps VALUES ('2007-02-24 04:00:00', 9.5);INSERT INTO gltemps VALUES ('2007-02-24 05:00:00', 9.19999981);INSERT INTO gltemps VALUES ('2007-02-24 06:00:00', 8.80000019);INSERT INTO gltemps VALUES ('2007-02-24 07:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 08:00:00', 8.80000019);INSERT INTO gltemps VALUES ('2007-02-24 09:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 10:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 11:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 12:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 13:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-24 14:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-24 15:00:00', 12);INSERT INTO gltemps VALUES ('2007-02-24 16:00:00', 13);INSERT INTO gltemps VALUES ('2007-02-24 17:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-24 18:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-24 19:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-24 20:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-24 21:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-24 22:00:00', 8.30000019);INSERT INTO gltemps VALUES ('2007-02-24 23:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-02-25 00:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-02-25 01:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 02:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 03:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 04:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-25 05:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-25 06:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 07:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 08:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-25 09:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 10:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 11:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-25 12:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-25 13:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-25 14:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-25 15:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-25 16:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-25 17:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-25 18:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-25 19:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-25 20:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-25 21:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-25 22:00:00', 6.9000001);INSERT INTO gltemps VALUES ('2007-02-25 23:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-26 01:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-26 02:00:00', 5.80000019);INSERT INTO gltemps VALUES ('2007-02-26 03:00:00', 7.19999981);INSERT INTO gltemps VALUES ('2007-02-26 04:00:00', 7.19999981);INSERT INTO gltemps VALUES ('2007-02-26 05:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 06:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 08:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 09:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 12:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 13:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-26 14:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-26 15:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 16:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-26 17:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 18:00:00', 7.30000019);INSERT INTO gltemps VALUES ('2007-02-26 19:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 20:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-26 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-26 22:00:00', 6.0999999);INSERT INTO gltemps VALUES ('2007-02-27 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 03:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 04:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 05:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-27 06:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-27 07:00:00', 5.19999981);INSERT INTO gltemps VALUES ('2007-02-27 08:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-27 09:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-02-27 10:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 11:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 12:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-27 13:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 14:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-02-27 15:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-27 16:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-27 17:00:00', 4.9000001);INSERT INTO gltemps VALUES ('2007-02-27 18:00:00', 5);INSERT INTO gltemps VALUES ('2007-02-27 19:00:00', 6);INSERT INTO gltemps VALUES ('2007-02-27 20:00:00', 7);INSERT INTO gltemps VALUES ('2007-02-27 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-27 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-02-27 23:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-28 00:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-28 01:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-28 02:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-28 03:00:00', 11.3000002);INSERT INTO gltemps VALUES ('2007-02-28 04:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-28 05:00:00', 10.8999996);INSERT INTO gltemps VALUES ('2007-02-28 06:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 07:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 08:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 09:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 10:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 11:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 12:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-28 13:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 14:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-28 15:00:00', 11);INSERT INTO gltemps VALUES ('2007-02-28 16:00:00', 11.5);INSERT INTO gltemps VALUES ('2007-02-28 17:00:00', 11.6999998);INSERT INTO gltemps VALUES ('2007-02-28 18:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-28 19:00:00', 10);INSERT INTO gltemps VALUES ('2007-02-28 20:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-28 21:00:00', 9);INSERT INTO gltemps VALUES ('2007-02-28 22:00:00', 9.10000038);INSERT INTO gltemps VALUES ('2007-02-28 23:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 00:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 01:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 02:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 03:00:00', 9.19999981);INSERT INTO gltemps VALUES ('2007-03-01 04:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 05:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-01 06:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 07:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-01 08:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 09:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 10:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 11:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 13:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 14:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 16:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 17:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 18:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-01 19:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-01 20:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-01 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-01 22:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-01 23:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 00:00:00', 6.5999999);INSERT INTO gltemps VALUES ('2007-03-02 01:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 02:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 03:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 04:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 05:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-02 06:00:00', 5.80000019);INSERT INTO gltemps VALUES ('2007-03-02 07:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-02 08:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-02 09:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-02 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 11:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 12:00:00', 8.10000038);INSERT INTO gltemps VALUES ('2007-03-02 13:00:00', 6.69999981);INSERT INTO gltemps VALUES ('2007-03-02 14:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-02 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-02 16:00:00', 9.39999962);INSERT INTO gltemps VALUES ('2007-03-02 17:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-02 18:00:00', 9.39999962);INSERT INTO gltemps VALUES ('2007-03-02 19:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-02 20:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-02 21:00:00', 4.5);INSERT INTO gltemps VALUES ('2007-03-02 22:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-02 23:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-03 00:00:00', 4.80000019);INSERT INTO gltemps VALUES ('2007-03-03 01:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 03:00:00', 4.80000019);INSERT INTO gltemps VALUES ('2007-03-03 04:00:00', 4.69999981);INSERT INTO gltemps VALUES ('2007-03-03 05:00:00', 4.80000019);INSERT INTO gltemps VALUES ('2007-03-03 06:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 07:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-03 08:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-03 09:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-03 10:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-03 11:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-03 12:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-03 13:00:00', 6.5);INSERT INTO gltemps VALUES ('2007-03-03 14:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 15:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 16:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 17:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-03 18:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-03 19:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 20:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 22:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-03 23:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-04 00:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-04 01:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-04 02:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-04 03:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-04 04:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-04 05:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-04 06:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-04 07:00:00', 3.79999995);INSERT INTO gltemps VALUES ('2007-03-04 08:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-04 09:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-04 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-04 11:00:00', 7.69999981);INSERT INTO gltemps VALUES ('2007-03-04 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-04 13:00:00', 11.3999996);INSERT INTO gltemps VALUES ('2007-03-04 14:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-04 15:00:00', 12.5);INSERT INTO gltemps VALUES ('2007-03-04 16:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-04 17:00:00', 14.1000004);INSERT INTO gltemps VALUES ('2007-03-04 18:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-04 19:00:00', 12);INSERT INTO gltemps VALUES ('2007-03-04 20:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-04 21:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-04 23:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-05 00:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-05 01:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-05 02:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-05 03:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 04:00:00', 10.3000002);INSERT INTO gltemps VALUES ('2007-03-05 05:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 06:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 07:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 08:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 09:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 10:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-05 11:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 13:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-05 14:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-05 15:00:00', 14);INSERT INTO gltemps VALUES ('2007-03-05 16:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-05 17:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-05 18:00:00', 9.5);INSERT INTO gltemps VALUES ('2007-03-05 19:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-05 20:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-05 21:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-05 22:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-05 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-06 00:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-06 01:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-06 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-06 03:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-06 04:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-06 05:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-06 06:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-06 07:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-06 08:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-06 09:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-06 10:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-06 11:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-06 12:00:00', 12);INSERT INTO gltemps VALUES ('2007-03-06 13:00:00', 12.8000002);INSERT INTO gltemps VALUES ('2007-03-06 14:00:00', 12.6000004);INSERT INTO gltemps VALUES ('2007-03-06 15:00:00', 12.8000002);INSERT INTO gltemps VALUES ('2007-03-06 16:00:00', 13.8000002);INSERT INTO gltemps VALUES ('2007-03-06 17:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-06 18:00:00', 11.5);INSERT INTO gltemps VALUES ('2007-03-06 19:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-06 20:00:00', 9.89999962);INSERT INTO gltemps VALUES ('2007-03-06 21:00:00', 9.60000038);INSERT INTO gltemps VALUES ('2007-03-06 22:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-06 23:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-07 00:00:00', 9.60000038);INSERT INTO gltemps VALUES ('2007-03-07 01:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-07 02:00:00', 9.39999962);INSERT INTO gltemps VALUES ('2007-03-07 03:00:00', 9.30000019);INSERT INTO gltemps VALUES ('2007-03-07 04:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-07 05:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-07 06:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-07 07:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-07 08:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-07 09:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-07 10:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-07 11:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-07 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-07 13:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-07 14:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-07 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-07 16:00:00', 9.39999962);INSERT INTO gltemps VALUES ('2007-03-07 17:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-07 18:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-07 19:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-07 20:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-03-07 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-07 22:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-07 23:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-08 00:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-08 01:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-08 02:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-08 03:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-08 04:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-08 05:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-08 06:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-08 07:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-08 08:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-08 09:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-08 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-08 11:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-08 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-08 13:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-08 14:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-08 15:00:00', 12);INSERT INTO gltemps VALUES ('2007-03-08 16:00:00', 12);INSERT INTO gltemps VALUES ('2007-03-08 17:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-08 18:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-08 19:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-08 20:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-08 21:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-08 22:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-08 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-09 00:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-09 01:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-09 02:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-09 03:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-09 04:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-09 05:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-09 06:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-09 07:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-09 08:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-09 09:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-09 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-09 11:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-09 12:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-09 13:00:00', 10.6999998);INSERT INTO gltemps VALUES ('2007-03-09 14:00:00', 10.6999998);INSERT INTO gltemps VALUES ('2007-03-09 15:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-09 16:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-09 17:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-09 18:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-09 19:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-09 20:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-09 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-09 22:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-09 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-10 00:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-10 01:00:00', 5.19999981);INSERT INTO gltemps VALUES ('2007-03-10 02:00:00', 4.19999981);INSERT INTO gltemps VALUES ('2007-03-10 03:00:00', 3);INSERT INTO gltemps VALUES ('2007-03-10 04:00:00', 3);INSERT INTO gltemps VALUES ('2007-03-10 05:00:00', 2.5);INSERT INTO gltemps VALUES ('2007-03-10 06:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-10 07:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-10 08:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-10 09:00:00', 2);INSERT INTO gltemps VALUES ('2007-03-10 10:00:00', 5);INSERT INTO gltemps VALUES ('2007-03-10 11:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-10 12:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-10 13:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-10 14:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-10 15:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-10 16:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-10 17:00:00', 10.8000002);INSERT INTO gltemps VALUES ('2007-03-10 18:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-10 19:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-10 20:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-10 21:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-10 22:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-10 23:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-11 00:00:00', 6.4000001);INSERT INTO gltemps VALUES ('2007-03-11 01:00:00', 5.80000019);INSERT INTO gltemps VALUES ('2007-03-11 02:00:00', 6.30000019);INSERT INTO gltemps VALUES ('2007-03-11 03:00:00', 5.9000001);INSERT INTO gltemps VALUES ('2007-03-11 04:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-03-11 05:00:00', 3);INSERT INTO gltemps VALUES ('2007-03-11 06:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-11 07:00:00', 3);INSERT INTO gltemps VALUES ('2007-03-11 08:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-11 09:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-11 10:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-11 11:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-11 12:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-11 13:00:00', 12);INSERT INTO gltemps VALUES ('2007-03-11 14:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-11 15:00:00', 14);INSERT INTO gltemps VALUES ('2007-03-11 16:00:00', 14.1999998);INSERT INTO gltemps VALUES ('2007-03-11 17:00:00', 14.8000002);INSERT INTO gltemps VALUES ('2007-03-11 18:00:00', 15);INSERT INTO gltemps VALUES ('2007-03-11 19:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-11 20:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-11 21:00:00', 10.1000004);INSERT INTO gltemps VALUES ('2007-03-11 22:00:00', 9.10000038);INSERT INTO gltemps VALUES ('2007-03-11 23:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-03-12 00:00:00', 7.5);INSERT INTO gltemps VALUES ('2007-03-12 01:00:00', 6.19999981);INSERT INTO gltemps VALUES ('2007-03-12 02:00:00', 6);INSERT INTO gltemps VALUES ('2007-03-12 03:00:00', 5.5);INSERT INTO gltemps VALUES ('2007-03-12 04:00:00', 3.5999999);INSERT INTO gltemps VALUES ('2007-03-12 05:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-03-12 06:00:00', 4.69999981);INSERT INTO gltemps VALUES ('2007-03-12 07:00:00', 4.9000001);INSERT INTO gltemps VALUES ('2007-03-12 08:00:00', 4.4000001);INSERT INTO gltemps VALUES ('2007-03-12 09:00:00', 2.29999995);INSERT INTO gltemps VALUES ('2007-03-12 10:00:00', 5.9000001);INSERT INTO gltemps VALUES ('2007-03-12 11:00:00', 9.80000019);INSERT INTO gltemps VALUES ('2007-03-12 12:00:00', 12.5);INSERT INTO gltemps VALUES ('2007-03-12 13:00:00', 13.8000002);INSERT INTO gltemps VALUES ('2007-03-12 14:00:00', 15.3000002);INSERT INTO gltemps VALUES ('2007-03-12 15:00:00', 16.5);INSERT INTO gltemps VALUES ('2007-03-12 16:00:00', 17.1000004);INSERT INTO gltemps VALUES ('2007-03-12 17:00:00', 17.5);INSERT INTO gltemps VALUES ('2007-03-12 18:00:00', 17.2000008);INSERT INTO gltemps VALUES ('2007-03-12 19:00:00', 15.6999998);INSERT INTO gltemps VALUES ('2007-03-12 20:00:00', 13.3999996);INSERT INTO gltemps VALUES ('2007-03-12 21:00:00', 12.8999996);INSERT INTO gltemps VALUES ('2007-03-12 22:00:00', 11.3999996);INSERT INTO gltemps VALUES ('2007-03-12 23:00:00', 10.1000004);INSERT INTO gltemps VALUES ('2007-03-13 00:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-13 01:00:00', 5.5999999);INSERT INTO gltemps VALUES ('2007-03-13 02:00:00', 4.5999999);INSERT INTO gltemps VALUES ('2007-03-13 03:00:00', 3);INSERT INTO gltemps VALUES ('2007-03-13 04:00:00', 2.0999999);INSERT INTO gltemps VALUES ('2007-03-13 05:00:00', 2.29999995);INSERT INTO gltemps VALUES ('2007-03-13 06:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-13 07:00:00', 0.600000024);INSERT INTO gltemps VALUES ('2007-03-13 08:00:00', 0.400000006);INSERT INTO gltemps VALUES ('2007-03-13 09:00:00', 2.79999995);INSERT INTO gltemps VALUES ('2007-03-13 10:00:00', 6.30000019);INSERT INTO gltemps VALUES ('2007-03-13 11:00:00', 8.69999981);INSERT INTO gltemps VALUES ('2007-03-13 12:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-13 13:00:00', 12.1999998);INSERT INTO gltemps VALUES ('2007-03-13 14:00:00', 14.1999998);INSERT INTO gltemps VALUES ('2007-03-13 15:00:00', 15.1000004);INSERT INTO gltemps VALUES ('2007-03-13 16:00:00', 15.3000002);INSERT INTO gltemps VALUES ('2007-03-13 17:00:00', 15.1000004);INSERT INTO gltemps VALUES ('2007-03-13 18:00:00', 14.6000004);INSERT INTO gltemps VALUES ('2007-03-13 19:00:00', 13.1000004);INSERT INTO gltemps VALUES ('2007-03-13 20:00:00', 11.3000002);INSERT INTO gltemps VALUES ('2007-03-13 21:00:00', 10.3000002);INSERT INTO gltemps VALUES ('2007-03-13 22:00:00', 8.39999962);INSERT INTO gltemps VALUES ('2007-03-13 23:00:00', 7.80000019);INSERT INTO gltemps VALUES ('2007-03-14 00:00:00', 6.80000019);INSERT INTO gltemps VALUES ('2007-03-14 01:00:00', 7);INSERT INTO gltemps VALUES ('2007-03-14 02:00:00', 6.69999981);INSERT INTO gltemps VALUES ('2007-03-14 03:00:00', 6.69999981);INSERT INTO gltemps VALUES ('2007-03-14 04:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-03-14 05:00:00', 5.19999981);INSERT INTO gltemps VALUES ('2007-03-14 06:00:00', 5.19999981);INSERT INTO gltemps VALUES ('2007-03-14 07:00:00', 5.69999981);INSERT INTO gltemps VALUES ('2007-03-14 08:00:00', 5.30000019);INSERT INTO gltemps VALUES ('2007-03-14 09:00:00', 4.9000001);INSERT INTO gltemps VALUES ('2007-03-14 10:00:00', 6.0999999);INSERT INTO gltemps VALUES ('2007-03-14 11:00:00', 8.80000019);INSERT INTO gltemps VALUES ('2007-03-14 12:00:00', 10.6999998);INSERT INTO gltemps VALUES ('2007-03-14 13:00:00', 11.1000004);INSERT INTO gltemps VALUES ('2007-03-14 14:00:00', 13.5);INSERT INTO gltemps VALUES ('2007-03-14 15:00:00', 13.8999996);INSERT INTO gltemps VALUES ('2007-03-14 16:00:00', 14.1999998);INSERT INTO gltemps VALUES ('2007-03-14 17:00:00', 14.5);INSERT INTO gltemps VALUES ('2007-03-14 18:00:00', 13.8999996);INSERT INTO gltemps VALUES ('2007-03-14 19:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-14 20:00:00', 10.8999996);INSERT INTO gltemps VALUES ('2007-03-14 21:00:00', 8.89999962);INSERT INTO gltemps VALUES ('2007-03-14 22:00:00', 7.4000001);INSERT INTO gltemps VALUES ('2007-03-14 23:00:00', 5.5999999);INSERT INTO gltemps VALUES ('2007-03-15 00:00:00', 4.19999981);INSERT INTO gltemps VALUES ('2007-03-15 01:00:00', 3.70000005);INSERT INTO gltemps VALUES ('2007-03-15 02:00:00', 3);INSERT INTO gltemps VALUES ('2007-03-15 03:00:00', 1.89999998);INSERT INTO gltemps VALUES ('2007-03-15 04:00:00', 1.29999995);INSERT INTO gltemps VALUES ('2007-03-15 05:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-15 06:00:00', -0.300000012);INSERT INTO gltemps VALUES ('2007-03-15 07:00:00', -1.29999995);INSERT INTO gltemps VALUES ('2007-03-15 08:00:00', -1.20000005);INSERT INTO gltemps VALUES ('2007-03-15 09:00:00', -0.5);INSERT INTO gltemps VALUES ('2007-03-15 10:00:00', 3.4000001);INSERT INTO gltemps VALUES ('2007-03-15 11:00:00', 7.0999999);INSERT INTO gltemps VALUES ('2007-03-15 12:00:00', 10.5);INSERT INTO gltemps VALUES ('2007-03-15 13:00:00', 12);INSERT INTO gltemps VALUES ('2007-03-15 14:00:00', 13.6000004);INSERT INTO gltemps VALUES ('2007-03-15 15:00:00', 14.5);INSERT INTO gltemps VALUES ('2007-03-15 16:00:00', 15.6000004);INSERT INTO gltemps VALUES ('2007-03-15 17:00:00', 16.1000004);INSERT INTO gltemps VALUES ('2007-03-15 18:00:00', 15.1000004);INSERT INTO gltemps VALUES ('2007-03-15 19:00:00', 13.1000004);INSERT INTO gltemps VALUES ('2007-03-15 20:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-15 21:00:00', 10.6000004);INSERT INTO gltemps VALUES ('2007-03-15 22:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-15 23:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-16 00:00:00', 7.0999999);INSERT INTO gltemps VALUES ('2007-03-16 01:00:00', 5.69999981);INSERT INTO gltemps VALUES ('2007-03-16 02:00:00', 5.0999999);INSERT INTO gltemps VALUES ('2007-03-16 03:00:00', 3.70000005);INSERT INTO gltemps VALUES ('2007-03-16 04:00:00', 3.5999999);INSERT INTO gltemps VALUES ('2007-03-16 05:00:00', 2.0999999);INSERT INTO gltemps VALUES ('2007-03-16 06:00:00', 2.5999999);INSERT INTO gltemps VALUES ('2007-03-16 07:00:00', 2.5999999);INSERT INTO gltemps VALUES ('2007-03-16 08:00:00', 1);INSERT INTO gltemps VALUES ('2007-03-16 09:00:00', 0.699999988);INSERT INTO gltemps VALUES ('2007-03-16 10:00:00', 4);INSERT INTO gltemps VALUES ('2007-03-16 11:00:00', 5.80000019);INSERT INTO gltemps VALUES ('2007-03-16 12:00:00', 7.5999999);INSERT INTO gltemps VALUES ('2007-03-16 13:00:00', 9.30000019);INSERT INTO gltemps VALUES ('2007-03-16 14:00:00', 11.6000004);INSERT INTO gltemps VALUES ('2007-03-16 15:00:00', 13);INSERT INTO gltemps VALUES ('2007-03-16 16:00:00', 12.3999996);INSERT INTO gltemps VALUES ('2007-03-16 17:00:00', 12.1999998);INSERT INTO gltemps VALUES ('2007-03-16 18:00:00', 11.8999996);INSERT INTO gltemps VALUES ('2007-03-16 19:00:00', 11.3999996);INSERT INTO gltemps VALUES ('2007-03-16 20:00:00', 10.8000002);INSERT INTO gltemps VALUES ('2007-03-16 21:00:00', 10.5);INSERT INTO gltemps VALUES ('2007-03-16 22:00:00', 9.89999962);INSERT INTO gltemps VALUES ('2007-03-16 23:00:00', 9.19999981);INSERT INTO gltemps VALUES ('2007-03-17 00:00:00', 9);INSERT INTO gltemps VALUES ('2007-03-17 01:00:00', 8.60000038);INSERT INTO gltemps VALUES ('2007-03-17 02:00:00', 8.10000038);INSERT INTO gltemps VALUES ('2007-03-17 03:00:00', 8.30000019);INSERT INTO gltemps VALUES ('2007-03-17 04:00:00', 8.39999962);INSERT INTO gltemps VALUES ('2007-03-17 05:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-03-17 06:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-03-17 07:00:00', 8.5);INSERT INTO gltemps VALUES ('2007-03-17 08:00:00', 8.39999962);INSERT INTO gltemps VALUES ('2007-03-17 09:00:00', 8);INSERT INTO gltemps VALUES ('2007-03-17 10:00:00', 7.4000001);INSERT INTO gltemps VALUES ('2007-03-17 11:00:00', 7.80000019);INSERT INTO gltemps VALUES ('2007-03-17 12:00:00', 8.39999962);INSERT INTO gltemps VALUES ('2007-03-17 13:00:00', 8.69999981);INSERT INTO gltemps VALUES ('2007-03-17 14:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-17 15:00:00', 10);INSERT INTO gltemps VALUES ('2007-03-17 16:00:00', 11);INSERT INTO gltemps VALUES ('2007-03-17 17:00:00', 11.3999996);INSERT INTO gltemps VALUES ('2007-0


Power i-Daten mit MS Excel abfragen, aktualisieren ... · Abfragen auf mehreren Systemen 6 Die Upload-Option 7 ... Überblick i-Daten mit Excel abfragen, komfortabel bearbeiten Einfach

Power i-Daten mit MS Excel abfragen, aktualisieren ... · Abfragen auf mehreren Systemen 6 Die Upload-Option 7 ... Überblick i-Daten mit Excel abfragen, komfortabel bearbeiten Einfach

Documents
+LF Haus Orr 2019 190104...•Mietmobiliar MODERN (inkl. Auf-und Abbaukosten, in dieser Location besteht eine Mobiliarbindung) • Schalenstuhl, weiß 4,40 Euro • Tafeltisch, 120

+LF Haus Orr 2019 190104...•Mietmobiliar MODERN (inkl. Auf-und Abbaukosten, in dieser Location besteht eine Mobiliarbindung) • Schalenstuhl, weiß 4,40 Euro • Tafeltisch, 120

Documents
WIDERSPRUCHSVERFAHREN - gerd-pfeffer.de · widerspruchsverfahren rechtsschutz durch die (bau-)verwaltung gerd pfeffer orr beim regierungsprÄsidium tÜbingen - referat baurecht -

WIDERSPRUCHSVERFAHREN - gerd-pfeffer.de · widerspruchsverfahren rechtsschutz durch die (bau-)verwaltung gerd pfeffer orr beim regierungsprÄsidium tÜbingen - referat baurecht -

Documents
Wirtschaftsinformatik SQL/QBE1 Abfragen mit QBE und SQL Wirtschaftsinformatik II

Wirtschaftsinformatik SQL/QBE1 Abfragen mit QBE und SQL Wirtschaftsinformatik II

Documents
nagios - Thomas Schneider - Session 8 Track 4FILE/T4S8-nagios.pdf · nagios im Überblick Überwachungsmethoden Ports abfragen snmp, http, ldap, … SNMP abfragen was auch immer der

nagios - Thomas Schneider - Session 8 Track 4FILE/T4S8-nagios.pdf · nagios im Überblick Überwachungsmethoden Ports abfragen snmp, http, ldap, … SNMP abfragen was auch immer der

Documents
Die Abfragen Das Prinzip der Abfrage. Mit Abfragen stellt man Fragen über die Daten, die Access in Tabelle speichert. Bemerkungen: Das Abfrage ist die

Die Abfragen Das Prinzip der Abfrage. Mit Abfragen stellt man Fragen über die Daten, die Access in Tabelle speichert. Bemerkungen: Das Abfrage ist die

Documents
MS Excel 2013 – Daten auswerten und abfragen - Berlin.de · Excel 2013 Verwaltungsakademie Berlin Daten auswerten/abfragen Verwaltungsakademie Berlin Seite 5 1 Datenbank Im Prinzip

MS Excel 2013 – Daten auswerten und abfragen - Berlin.de · Excel 2013 Verwaltungsakademie Berlin Daten auswerten/abfragen Verwaltungsakademie Berlin Seite 5 1 Datenbank Im Prinzip

Documents
Etikettierungsstrukturen und Abfragen in Emu Jonathan Harrington

Etikettierungsstrukturen und Abfragen in Emu Jonathan Harrington

Documents
Betrieb von Datenbanken Marco Skulschus & Marcus Wiederstein Einfache Abfragen Lehrbuch, Kapitel 2

Betrieb von Datenbanken Marco Skulschus & Marcus Wiederstein Einfache Abfragen Lehrbuch, Kapitel 2

Documents
Betrieb von Datenbanken Marco Skulschus & Marcus Wiederstein Komplexe Abfragen Lehrbuch, Kapitel 3

Betrieb von Datenbanken Marco Skulschus & Marcus Wiederstein Komplexe Abfragen Lehrbuch, Kapitel 3

Documents
Baacheello orr uoff sBBussiinneesss BA

Baacheello orr uoff sBBussiinneesss BA

Documents
Neues zum Förderprojekt Betreuungsstation für schwerst ... · Rubrik „News“ / BUSZ Station, Zambales Philippinen, Valerie Smith-Orr Neues zum Förderprojekt Betreuungsstation

Neues zum Förderprojekt Betreuungsstation für schwerst ... · Rubrik „News“ / BUSZ Station, Zambales Philippinen, Valerie Smith-Orr Neues zum Förderprojekt Betreuungsstation

Documents
André Minhorst Das Access 2003 · PDF file128 3 Abfragen Abfragen werden Sie überall antreffen: Als Datenherkunft von Formularen und Berichten, als Datensatzherkunft von Kombinations-

André Minhorst Das Access 2003 · PDF file128 3 Abfragen Abfragen werden Sie überall antreffen: Als Datenherkunft von Formularen und Berichten, als Datensatzherkunft von Kombinations-

Documents
Die Abfragen

Die Abfragen

Documents
SERVICEÜBERNAHME DURCH MEDIMAX OFFENBURG · 2020. 10. 2. · ORR Ä -ZUBEH Ö R 20% TT ORR Ä TIONS-GER Ä ZUBEH Ö R S6_KW41/20_V113 Alle Preise Abholpreise. Solange Vorrat reicht

SERVICEÜBERNAHME DURCH MEDIMAX OFFENBURG · 2020. 10. 2. · ORR Ä -ZUBEH Ö R 20% TT ORR Ä TIONS-GER Ä ZUBEH Ö R S6_KW41/20_V113 Alle Preise Abholpreise. Solange Vorrat reicht

Documents
Praktische Anwendung – Abfragen erstellen

Praktische Anwendung – Abfragen erstellen

Documents
Björn Becker Integration von SNMP Abfragen und SNMP-Traps in Nagios Projektpräsentation 25.06.2007 Integration von SNMP Abfragen und SNMP-Traps in Nagios

Björn Becker Integration von SNMP Abfragen und SNMP-Traps in Nagios Projektpräsentation 25.06.2007 Integration von SNMP Abfragen und SNMP-Traps in Nagios

Documents
Prüfen Sie Ihre ABAP SQL Abfragen auf SAP HANA Tauglichkeit

Prüfen Sie Ihre ABAP SQL Abfragen auf SAP HANA Tauglichkeit

Technology
Abfragen aus einer Sprachdatenbank Jonathan Harrington

Abfragen aus einer Sprachdatenbank Jonathan Harrington

Documents
MySQL: SELECT-Abfragen über mehrere Tabellen (JOINs) · MySQL: SELECT-Abfragen über mehrere Tabellen (JOINs) Grau hinterlegte Folien enthalten Detailthemen und sind nicht superwichtig

MySQL: SELECT-Abfragen über mehrere Tabellen (JOINs) · MySQL: SELECT-Abfragen über mehrere Tabellen (JOINs) Grau hinterlegte Folien enthalten Detailthemen und sind nicht superwichtig

Documents
Heidenreichstein. Zusammenarbeit der Institutionen Gegenseitige Besuche bei diversen Festen Gemeinsame Theateraufführungen organisieren Einladung der

Heidenreichstein. Zusammenarbeit der Institutionen Gegenseitige Besuche bei diversen Festen Gemeinsame Theateraufführungen organisieren Einladung der

Documents
Schüttungs-Messungen an diversen Quellen im Solothurner Jura...Schüttungs-Messungen an diversen Quellen im Solothurner Jura Gänselochquelle in Gänsbrunnen. Das Quellwasser wird

Schüttungs-Messungen an diversen Quellen im Solothurner Jura...Schüttungs-Messungen an diversen Quellen im Solothurner Jura Gänselochquelle in Gänsbrunnen. Das Quellwasser wird

Documents
129 - Diversen

129 - Diversen

Documents
St. Wiedemann Praktische Anwendung – Abfragen erstellen

St. Wiedemann Praktische Anwendung – Abfragen erstellen

Documents
123 - Diversen

123 - Diversen

Documents
124 - Diversen

124 - Diversen

Documents
SQL Überblick Abfragen aus einer Tabelle Abfragen aus mehreren Tabellen

SQL Überblick Abfragen aus einer Tabelle Abfragen aus mehreren Tabellen

Documents
Erstellen einer Datenbank Datenbankabfragen. Überblick Semantisches Modell Die fünf Stationen Logisches Modell Softwaremäßige Implementierung Abfragen

Erstellen einer Datenbank Datenbankabfragen. Überblick Semantisches Modell Die fünf Stationen Logisches Modell Softwaremäßige Implementierung Abfragen

Documents
B iel18 1a b ParadoxeInterventionenbei diversen Problemen · Kriz:GrundkonzeptederPsychotherapie,6.überarb.Auflage.Weinheim:BeltzPVU2007 Beispiel18.1a/b ParadoxeInterventionenbei

B iel18 1a b ParadoxeInterventionenbei diversen Problemen · Kriz:GrundkonzeptederPsychotherapie,6.überarb.Auflage.Weinheim:BeltzPVU2007 Beispiel18.1a/b ParadoxeInterventionenbei

Documents
Kompetenzen sichtbar machen mit Open Badges · Badges Ilona Buchem / Dominic Orr / Christine Brunn . NR. 48 / OKTOBER 2019 . Kompetenzen sichtbar . machen mit Open . Badges . Abschlussbericht

Kompetenzen sichtbar machen mit Open Badges · Badges Ilona Buchem / Dominic Orr / Christine Brunn . NR. 48 / OKTOBER 2019 . Kompetenzen sichtbar . machen mit Open . Badges . Abschlussbericht

Documents