windowfunctionSchema_3.sql

DROP TABLE IF EXISTS demand;

CREATE TABLE demand (
  product VARCHAR(10),
  location VARCHAR(10),
  sales INT,
  refunds INT
);


INSERT INTO demand
  (product, location, sales, refunds)
VALUES
  ("A", "S1", 9, 2),
  ("B", "S1", 8, 1),
  ("B", "S1", 7, 3),
  ("B", "S2", 51, 8),
  ("C", "S2", 33, 10),
  ("D", "S2", 12, 3),
  ("A", "S2", 10, 2),
  ("B", "S2", 152, 17),
  ("E", "S3", 101, 23),
  ("C", "S3", 73, 12),
  ("F", "S3", 63, 19),
  ("F", "S3", 23, 4),
  ("D", "S3", 5, 0),
  ("A", "S3", 5, 0);