Mercurial > hg > ooxml

comparison sample2_1.sql @ 55:05cf88c20cc5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
sample I/O pair, with range annotations
author Henry S. Thompson <ht@markup.co.uk>
date Tue, 30 May 2017 09:52:49 +0100
parents
children
comparison
equal deleted inserted replaced
54:191c95187e87 55:05cf88c20cc5
1 CREATE TABLE sample2_1_raw
2 (
3 date date,
4 offered int,
5 batch int primary key,
6 completed int,
7 rejected int,
8 directory text,
9 AMT_label text
10 );
11
12 CREATE VIEW sample2_1
13 (date, offered,
14 target,
15 batch, completed, rejected,
16 reject_percent,
17 directory, AMT_label)
18 AS SELECT
19 date, offered,
20 offered-rejected,
21 batch, completed, rejected,
22 rejected/completed,
23 directory, AMT_label
24 FROM sample2_1_raw;
25
26 INSERT INTO sample2_1_raw VALUES
27 ('2010-04-02', 100, 6126, 12, NULL, 'ssq', '*Semantic Search Relevance 2'),
28 ('2010-04-09', 200, 6247, 17, 0, 'ssq', '*Semantic Search Relevance final'),
29 ('2010-04-09', 1, 6251, 1, NULL, 'ssq', '*submit test'),
30 ('2010-04-09', 1, 6252, 1, NULL, 'ssq', '*submit test'),
31 ('2010-04-09', 60, 6256, 24, 0, 'ssq', '*Semantic Search Relevance final'),
32 ('2010-04-12', 60, 6278, 0, NULL, 'ssq', '*Semantic Search Relevance final'),
33 ('2010-04-12', 86, 222547, 86, 26, 'ssq/upload3.csv', 'Semantic Search Relevance');