Skip to content
Snippets Groups Projects
Select Git revision
  • 584cc2215cb93a049b7500a8a81329e828c1f809
  • master default protected
2 results

ex12.sql

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;