
CREATE TABLE tmp (
	a int, 
	b bool, 
	c char, 
	d varchar(10), 
	e text);

INSERT INTO tmp (e,d,c,b,a) VALUES ('hello',null,'ab',54,76344);
INSERT INTO tmp (a,b,c,d) VALUES (null,false,'','abcdefghijklmnop');
INSERT INTO tmp VALUES (1,2,'b','','asdfsdfdsfdfdfd');

INSERT INTO tmp (a,b,e)
(SELECT Salary,Benefits,Position FROM EmployeeStatisticsTable WHERE false);

INSERT INTO tmp (a,b,e) 
SELECT Salary,Benefits>=12000,Position FROM EmployeeStatisticsTable;

INSERT INTO tmp (a,b,e) VALUES
(SELECT Salary,Benefits,Position FROM EmployeeStatisticsTable WHERE false);

SELECT * FROM tmp;

DROP TABLE tmp;
