← All lessons

INSERT

Add Eldoret, then SELECT.

Add a row, then SELECT so you see it.

Goal

Add Eldoret, then list cities.

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);
INSERT INTO sales VALUES ('Eldoret', 3, 120);
SELECT city, units 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);
INSERT INTO sales (city, units, shillings) VALUES ('Nakuru', 4, 160);
SELECT * FROM sales WHERE city IN ('Nakuru', 'Eldoret');
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);
INSERT INTO sales VALUES ('Eldoret', 3, 120);
SELECT COUNT(*) AS rows 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);
INSERT INTO sales VALUES ('Eldoret', 3, 120), ('Nakuru', 4, 160);
SELECT city FROM sales ORDER BY city;