SQL for medium article 1

red_wine_excel_example_one.sql

CREATE TABLE IF NOT EXISTS red_wine
                 (
                  id INTEGER PRIMARY KEY AUTOINCREMENT,
                  fixed_acidity REAL NOT NULL,
                  volatile_acidity REAL NOT NULL,
                  citric_acid REAL NOT NULL,
                  residual_sugar REAL NOT NULL,
                  chlorides REAL NOT NULL,
                  free_sulfur_dioxide INTEGER NOT NULL,
                  total_sulfur_dioxide INTEGER NOT NULL,
                  density REAL NOT NULL,
                  pH REAL NOT NULL,
                  sulphates REAL NOT NULL,
                  alcohol REAL NOT NULL,
                  quality INTEGER NOT NULL,
                  type TEXT NOT NULL
                );
INSERT INTO red_wine
                (
                  fixed_acidity,
                  volatile_acidity,
                  citric_acid,
                  residual_sugar,
                  chlorides,
                  free_sulfur_dioxide,
                  total_sulfur_dioxide,
                  density,
                  pH,
                  sulphates,
                  alcohol,
                  quality,
                  type
                )
VALUES
  (7.4, 0.7, 0, 1.9, 0.076, 11, 34, 0.9978, 3.51, 0.56, 9.4, 5, 'RED');