uWSBJv5M

1DROP TABLE IF EXISTS p6209;
2CREATE TABLE p6209 (
3    id INT NOT NULL,
4    PRIMARY KEY(id),
5    name VARCHAR(20) NOT NULL,
6    type VARCHAR(10) NOT NULL,
7    developer VARCHAR(20) NOT NULL
8);
9
10
11
12
13INSERT INTO p6204 (id, name, type, developer) VALUES (1,  'Win95',   'Win',  'Microsoft');
14INSERT INTO p6204 (id, name, type, developer) VALUES (2,  'Win98',   'Win',  'Microsoft');
15INSERT INTO p6204 (id, name, type, developer) VALUES (3,  'WinNT',  'Win',  'UnixF');
16INSERT INTO p6204 (id, name, type, developer) VALUES (4,  'WinXP',   'Win',     'Apple');
17INSERT INTO p6204 (id, name, type, developer) VALUES (5,  'Unix',   'Unix',     'UnixF');
18INSERT INTO p6204 (id, name, type, developer) VALUES (6,  'FreeBSD',   'Unix',     'Jobbs');
19INSERT INTO p6204 (id, name, type, developer) VALUES (7,  'Linux', 'Unix', 'UnixF');
20INSERT INTO p6204 (id, name, type, developer) VALUES (8,  'MacOS1', 'Mac', 'Apple');
21INSERT INTO p6204 (id, name, type, developer) VALUES (9,  'MacOS2',   'Mac', 'Apple');
22INSERT INTO p6204 (id, name, type, developer) VALUES (10, 'MacOS3',  'Mac', 'Jobbs');
23
24(?)SELECT * FROM p6208 WHERE name IN (&x);
25
26SELECT * FROM p6213 WHERE id <> CASE $1
27    WHEN 'first' THEN (SELECT id FROM p6213 ORDER BY name ASC LIMIT 1)
28    WHEN 'last' THEN (SELECT id FROM p6213 ORDER BY name DESC LIMIT 1)
29    ELSE -1
30    END;