Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus

machinelearningplus/windowfunctionSchema_1.sql

Created August 30, 2023 10:23
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/c95561c929a83b85356105965b2ac42f to your computer and use it in GitHub Desktop.
Save machinelearningplus/c95561c929a83b85356105965b2ac42f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
windowfunctionSchema_1.sql
DROP TABLE IF EXISTS demand2;
CREATE TABLE demand2 (
day INT,
qty FLOAT
);
INSERT INTO demand2
(day, qty)
VALUES
(1, 10),
(2, 6),
(3, 21),
(4, 9),
(6, 12),
(7, 18),
(8, 3),
(9, 6),
(10, 23);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment