5UCBEFpE

1DROP TABLE IF EXISTS p6205;
2    CREATE TABLE p6205 (
3        id INT NOT NULL AUTO_INCREMENT,
4        PRIMARY KEY(id),
5        name VARCHAR(20) CHARACTER SET utf8 NOT NULL,
6        type VARCHAR(10) CHARACTER SET utf8 NOT NULL,
7        developer VARCHAR(20) CHARACTER SET utf8 NOT NULL
8    )
9
10INSERT INTO p6205 (name, type, developer) VALUES
11    ('Pascal', 'Процед', 'Borland'),
12    ('C', 'Процед', 'Borland'),
13    ('Java', 'Процед', 'Java inc'),
14    ('C++', 'Объект', 'Java inc'),
15    ('Visual C', 'Объект', 'Microsoft'),
16    ('Visual Basic', 'Объект', 'Microsoft'),
17    ('Delphi', 'Объект', 'Borland'),
18    ('Lisp', 'Сценарн', 'IBM'),
19    ('Prolog', 'Сценарн', 'IBM'),
20    ('XML', 'Сценарн', 'Borland');"
21
22SELECT * FROM p6205 WHERE name IN ($x)
23
24SELECT type, COUNT(id) FROM p6205 
25    WHERE developer != '$1'
26    GROUP BY type"
27
28SELECT * FROM p6205
29    WHERE developer NOT IN
30    (SELECT developer FROM p6205
31    WHERE type = '$1')