Name columns and types. DROP first so the script reruns.

Goal

Create a cities table and select names.

DROP TABLE IF EXISTS cities;
CREATE TABLE cities (
  id INTEGER PRIMARY KEY,
  name TEXT,
  region TEXT
);
INSERT INTO cities VALUES
  (1, 'Nairobi', 'Capital'),
  (2, 'Mombasa', 'Coast'),
  (3, 'Kisumu', 'Lakeside');

SELECT name, region FROM cities;

DROP TABLE IF EXISTS kiosks;
CREATE TABLE kiosks (
  city TEXT,
  stall TEXT
);
INSERT INTO kiosks VALUES ('Nairobi', 'Ada'), ('Mombasa', 'Alan');
SELECT * FROM kiosks;

DROP TABLE IF EXISTS cities;
CREATE TABLE cities (
  id INTEGER PRIMARY KEY,
  name TEXT,
  region TEXT
);
INSERT INTO cities VALUES
  (1, 'Nairobi', 'Capital'),
  (2, 'Mombasa', 'Coast'),
  (3, 'Kisumu', 'Lakeside');

SELECT COUNT(*) AS n FROM cities;

DROP TABLE IF EXISTS prices;
CREATE TABLE prices (item TEXT, kes INTEGER);
INSERT INTO prices VALUES ('mango', 40), ('soda', 50);
SELECT item, kes FROM prices;