requetes.cql 1.69 KB
Newer Older
Thomas Le Gluher's avatar
Thomas Le Gluher committed
1 2 3 4 5 6
-- Question 1
CREATE TABLE finlande1(station text, annee int, mois int, jour int, heure int, min int, lat float, lon float, tmpf float, dwpf float, relh float, drct float, sknt float, p01i float, alti float, mslp float, vsby float, gust float, skyc1 text, skyc2 text, skyc3 text, skyc4 text, skyl1 float, skyl2 float, skyl3 float, skyl4 float, wxcodes text, ice_accretion_1hr float, ice_accretion_3hr float, ice_accretion_6hr float, peak_wind_gust float, peak_wind_drct float, peak_wind_time text,feel float, metar text, primary key((station, annee), mois, jour, heure, min) );
-- Question 2	
CREATE TABLE finlande2(station text, annee int, mois int, jour int, heure int, min int, lat float, lon float, tmpf float, dwpf float, relh float, drct float, sknt float, p01i float, alti float, mslp float, vsby float, gust float, skyc1 text, skyc2 text, skyc3 text, skyc4 text, skyl1 float, skyl2 float, skyl3 float, skyl4 float, wxcodes text, ice_accretion_1hr float, ice_accretion_3hr float, ice_accretion_6hr float, peak_wind_gust float, peak_wind_drct float, peak_wind_time text,feel float, metar text, primary key((annee, mois, jour, heure, min), lat, lon, station ));
-- Question 3
CREATE TABLE finlande3(station text, annee int, mois int, jour int, heure int, min int, lat float, lon float, tmpf float, dwpf float, relh float, drct float, sknt float, p01i float, alti float, mslp float, vsby float, gust float, skyc1 text, skyc2 text, skyc3 text, skyc4 text, skyl1 float, skyl2 float, skyl3 float, skyl4 float, wxcodes text, ice_accretion_1hr float, ice_accretion_3hr float, ice_accretion_6hr float, peak_wind_gust float, peak_wind_drct float, peak_wind_time text,feel float, metar text, primary key((annee), mois, jour, heure, min));