1
2
3
4
5
6
|
CREATE TABLE data1 (date DATE, money INTEGER);
INSERT INTO data1 VALUES ('2008/05/07', 75), ('2008/05/08', 70), ('2008/05/09', 80), ('2008/05/10', 100), ('2008/05/11', 200), ('2008/05/12', 100), ('2008/05/13', 50), ('2008/05/14', 200), ('2008/05/15', 2000);
CREATE TABLE data2 (date DATE, runtimeA REAL, runtimeB REAL);
INSERT INTO data2 VALUES ('2008/05/07', 75.32, 72.58), ('2008/05/08', 74.16, 71.36), ('2008/05/09', 76.58, 70.24), ('2008/05/10', 70.46, 69.56), ('2008/05/11', 69.27, 69.18), ('2008/05/12', 66.91, 68.45), ('2008/05/13', 60.94, 67.34), ('2008/05/14', 62.16, 66.93), ('2008/05/15', 59.47, 66.34);
CREATE TABLE test (col1 INTEGER, col2 REAL);
INSERT INTO test VALUES (1,111.1), (2,222.1);
|
