Skip to content

Instantly share code, notes, and snippets.

@nalgeon
Created November 5, 2021 08:33
Show Gist options
  • Save nalgeon/858c409b81ae3a676580cba6745d68ea to your computer and use it in GitHub Desktop.
Save nalgeon/858c409b81ae3a676580cba6745d68ea to your computer and use it in GitHub Desktop.
sales.db
select * from sales limit 10;
BEGIN TRANSACTION;
PRAGMA writable_schema=ON;
CREATE TABLE IF NOT EXISTS sales (
year integer,
month integer,
price integer,
quantity integer,
revenue integer
);
INSERT INTO "sales" VALUES(2019,1,60,200,12000);
INSERT INTO "sales" VALUES(2019,2,60,660,39600);
INSERT INTO "sales" VALUES(2019,3,60,400,24000);
INSERT INTO "sales" VALUES(2019,4,60,300,18000);
INSERT INTO "sales" VALUES(2019,5,60,440,26400);
INSERT INTO "sales" VALUES(2019,6,60,540,32400);
INSERT INTO "sales" VALUES(2019,7,60,440,26400);
INSERT INTO "sales" VALUES(2019,8,60,440,26400);
INSERT INTO "sales" VALUES(2019,9,60,250,15000);
INSERT INTO "sales" VALUES(2019,10,60,420,25200);
INSERT INTO "sales" VALUES(2019,11,60,495,29700);
INSERT INTO "sales" VALUES(2019,12,60,440,26400);
INSERT INTO "sales" VALUES(2020,1,60,450,27000);
INSERT INTO "sales" VALUES(2020,2,60,1020,61200);
INSERT INTO "sales" VALUES(2020,3,60,700,42000);
INSERT INTO "sales" VALUES(2020,4,60,700,42000);
INSERT INTO "sales" VALUES(2020,5,60,650,39000);
INSERT INTO "sales" VALUES(2020,6,60,880,52800);
INSERT INTO "sales" VALUES(2020,7,60,780,46800);
INSERT INTO "sales" VALUES(2020,8,60,550,33000);
INSERT INTO "sales" VALUES(2020,9,60,900,54000);
INSERT INTO "sales" VALUES(2020,10,60,950,57000);
INSERT INTO "sales" VALUES(2020,11,60,1045,62700);
INSERT INTO "sales" VALUES(2020,12,60,1100,66000);
PRAGMA writable_schema=OFF;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment