← All lessons

CSV as a table

Attach sales.csv or INSERT.

You can attach sales.csv from the banner, or INSERT the same rows.

Goal

Build the table from INSERT (same shape as the CSV).

DROP TABLE IF EXISTS sales;
CREATE TABLE sales (
  city TEXT,
  units INTEGER,
  shillings INTEGER
);
INSERT INTO sales VALUES
  ('Nairobi', 12, 480),
  ('Mombasa', 8, 320),
  ('Kisumu', 5, 200);

SELECT city, units, shillings FROM sales;
DROP TABLE IF EXISTS sales;
CREATE TABLE sales (city TEXT, units INTEGER, shillings INTEGER);
INSERT INTO sales VALUES
  ('Nairobi', 12, 480),
  ('Mombasa', 8, 320),
  ('Kisumu', 5, 200),
  ('Nakuru', 4, 160),
  ('Eldoret', 3, 120);
SELECT city, units FROM sales ORDER BY units DESC;
DROP TABLE IF EXISTS sales;
CREATE TABLE sales (
  city TEXT,
  units INTEGER,
  shillings INTEGER
);
INSERT INTO sales VALUES
  ('Nairobi', 12, 480),
  ('Mombasa', 8, 320),
  ('Kisumu', 5, 200);

SELECT SUM(shillings) AS till FROM sales;
DROP TABLE IF EXISTS sales;
CREATE TABLE sales (
  city TEXT,
  units INTEGER,
  shillings INTEGER
);
INSERT INTO sales VALUES
  ('Nairobi', 12, 480),
  ('Mombasa', 8, 320),
  ('Kisumu', 5, 200);

SELECT city FROM sales;