CREATE TABLE sample2_1_raw
(
 date	date,
 offered	int,
 batch		int primary key,
 completed	int,
 rejected	int,
 directory	text,
 AMT_label	text
);

CREATE VIEW sample2_1
(date, offered,
 target,
 batch, completed, rejected,
 reject_percent,
 directory, AMT_label)
 AS SELECT
 date, offered,
 offered-rejected,
 batch, completed, rejected,
 rejected/completed,
 directory, AMT_label
 FROM sample2_1_raw;

INSERT INTO sample2_1_raw VALUES
('2010-04-02', 100, 6126, 12, NULL, 'ssq', '*Semantic Search Relevance 2'),
('2010-04-09', 200, 6247, 17, 0, 'ssq', '*Semantic Search Relevance final'),
('2010-04-09', 1, 6251, 1, NULL, 'ssq', '*submit test'),
('2010-04-09', 1, 6252, 1, NULL, 'ssq', '*submit test'),
('2010-04-09', 60, 6256, 24, 0, 'ssq', '*Semantic Search Relevance final'),
('2010-04-12', 60, 6278, 0, NULL, 'ssq', '*Semantic Search Relevance final'),
('2010-04-12', 86, 222547, 86, 26, 'ssq/upload3.csv', 'Semantic Search Relevance');