sales.db

query.sql

select * from sales limit 10;

schema.sql

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;