Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus

machinelearningplus/windowfunctionSchema_2.sql

Created August 30, 2023 10:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save machinelearningplus/e2454925473a0e353e3f08f548e639a8 to your computer and use it in GitHub Desktop.
Save machinelearningplus/e2454925473a0e353e3f08f548e639a8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
windowfunctionSchema_2.sql
DROP TABLE IF EXISTS demand;
CREATE TABLE demand (
product VARCHAR(10),
day INT,
qty FLOAT
);
INSERT INTO demand
(product, day, qty)
VALUES
("A", 1, 10),
("A", 2, 6),
("A", 3, 21),
("A", 4, 9),
("A", 5, 19),
("B", 1, 12),
("B", 2, 18),
("B", 3, 3),
("B", 4, 6),
("B", 5, 23);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment