FREE AI-Enhanced Online PostgreSQL Compiler

Untitled*

You must execute the code again to save those values in the database.

-- INIT database
CREATE TABLE stock (
  item VARCHAR(100),
  stock numeric,
  date DATE
);

INSERT INTO stock(item, stock, date) VALUES ('Blade','10','2020-01-01');
INSERT INTO stock(item, stock, date) VALUES ('Blade','20','2020-01-02');
INSERT INTO stock(item, stock, date) VALUES ('Blade','30','2020-01-03');
INSERT INTO stock(item, stock, date) VALUES ('Blade','40','2020-01-04');
INSERT INTO stock(item, stock, date) VALUES ('Blade','50','2020-01-05');
INSERT INTO stock(item, stock, date) VALUES ('Blade','60','2020-01-06');
INSERT INTO stock(item, stock, date) VALUES ('Blade','70','2020-01-07');
INSERT INTO stock(item, stock, date) VALUES ('Table','10','2020-01-01');
INSERT INTO stock(item, stock, date) VALUES ('Table','20','2020-01-02');
INSERT INTO stock(item, stock, date) VALUES ('Table','30','2020-01-03');
INSERT INTO stock(item, stock, date) VALUES ('Table','40','2020-01-04');
INSERT INTO stock(item, stock, date) VALUES ('Table','50','2020-01-05');
INSERT INTO stock(item, stock, date) VALUES ('Table','60','2020-01-06');
INSERT INTO stock(item, stock, date) VALUES ('Table','70','2020-01-07');

CREATE TABLE rule (
  item VARCHAR(100),
  rule VARCHAR(100),
  value double precision
);

INSERT INTO rule(item, rule, value) VALUES ('Blade','cum_sum','2.5');
INSERT INTO rule(item, rule, value) VALUES ('Blade','lead_sum','2.5');
INSERT INTO rule(item, rule, value) VALUES ('Table','cum_sum','3');
INSERT INTO rule(item, rule, value) VALUES ('Table','lead_sum','3');

-- QUERY database
SELECT * FROM stock;
SELECT * FROM rule;

item	stock	date
Blade	10	2020-01-01
Blade	20	2020-01-02
Blade	30	2020-01-03
Blade	40	2020-01-04
Blade	50	2020-01-05
Blade	60	2020-01-06
Blade	70	2020-01-07
Table	10	2020-01-01
Table	20	2020-01-02
Table	30	2020-01-03
Table	40	2020-01-04
Table	50	2020-01-05
Table	60	2020-01-06
Table	70	2020-01-07

item	rule	value
Blade	cum_sum	2.5
Blade	lead_sum	2.5
Table	cum_sum	3
Table	lead_sum	3

CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1