Spaces:

Aniruddha7
/

QueryLensV2b

Running on Zero

QueryLensV2b / employee-sample-database /postgres /dataset_small /load_dept_manager.sql

Full deploy of QueryLensV2 (code + demo db) to a fresh Space

19dfd32 verified 2 days ago

719 Bytes

INSERT INTO dept_manager VALUES 
(10002,'d001','1985-01-01','1991-10-01'),

(10039,'d001','1991-10-01','9999-01-01'),

(10085,'d002','1985-01-01','1989-12-17'),

(10114,'d002','1989-12-17','9999-01-01'),

(10183,'d003','1985-01-01','1992-03-21'),

(10228,'d003','1992-03-21','9999-01-01'),

(10303,'d004','1985-01-01','1988-09-09'),

(10344,'d004','1988-09-09','1992-08-02'),

(10386,'d004','1992-08-02','1996-08-30'),

(10420,'d004','1996-08-30','9999-01-01'),

(10511,'d005','1985-01-01','1992-04-25'),

(10567,'d005','1992-04-25','9999-01-01'),

(10725,'d006','1985-01-01','1989-05-06'),

(10765,'d006','1989-05-06','1991-09-12'),

(10800,'d006','1991-09-12','1994-06-28'),

(10854,'d006','1994-06-28','9999-01-01');

	INSERT INTO dept_manager VALUES
	(10002,'d001','1985-01-01','1991-10-01'),

	(10039,'d001','1991-10-01','9999-01-01'),

	(10085,'d002','1985-01-01','1989-12-17'),

	(10114,'d002','1989-12-17','9999-01-01'),

	(10183,'d003','1985-01-01','1992-03-21'),

	(10228,'d003','1992-03-21','9999-01-01'),

	(10303,'d004','1985-01-01','1988-09-09'),

	(10344,'d004','1988-09-09','1992-08-02'),

	(10386,'d004','1992-08-02','1996-08-30'),

	(10420,'d004','1996-08-30','9999-01-01'),

	(10511,'d005','1985-01-01','1992-04-25'),

	(10567,'d005','1992-04-25','9999-01-01'),

	(10725,'d006','1985-01-01','1989-05-06'),

	(10765,'d006','1989-05-06','1991-09-12'),

	(10800,'d006','1991-09-12','1994-06-28'),

	(10854,'d006','1994-06-28','9999-01-01');