Skip to content
Snippets Groups Projects
Select Git revision
  • 1000cdf15ad09e34f00bf2970eff0932c38adc44
  • master default protected
  • feature9-2
  • feature8
  • feature7
  • feature6
  • featureBad
  • featuretwo
  • featureone
9 results

README.md

Blame
  • ex12.sql 424 B
    INSERT INTO Date (dateRep, day, month, year)
    SELECT DISTINCT dateRep, day, month, year FROM dataset;
    
    INSERT INTO Country (geoId, countriesAndTerritories, countryterritoryCode, continentExp, popData2018)
    SELECT DISTINCT geoId, countriesAndTerritories, countryterritoryCode, continentExp, popData2018 FROM dataset;
    
    INSERT INTO Virus (dateRep, geoId, cases, deaths)
    SELECT DISTINCT dateRep, geoId, cases, deaths FROM dataset;