SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Department(id integer, name text); CREATE TABLE Personal(id integer, id_head integer, id_dep integer, name text, sal integer); INSERT INTO Department VALUES(1, 'Финансы'); INSERT INTO Department VALUES(2, 'Риски'); INSERT INTO Department VALUES(3, 'Розница'); INSERT INTO Department VALUES(4, 'Безопасность'); INSERT INTO Department VALUES(1000, 'ДКК'); INSERT INTO Personal VALUES(1, 1, 2, 'Бегинс', 45000); INSERT INTO Personal VALUES(2, 1, 2, 'Поттер', 80000); INSERT INTO Personal VALUES(3, 2, 2, 'Чапаева', 100000); INSERT INTO Personal VALUES(4, 4, 4, 'Шилов', 65000); INSERT INTO Personal VALUES(10000, 5, 3, 'Наумов', 64500); SELECT Department.name, 'Г-жа' AS title, Personal.name FROM Personal, Department WHERE Personal.id_dep = Department.id AND Personal.name LIKE '%а' UNION SELECT Department.name, 'Г-н' AS title, Personal.name FROM Personal, Department WHERE Personal.id_dep = Department.id AND Personal.name NOT LIKE '%а';