SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Author ( SSN int, name varchar(30), age int, country varchar(30) ); CREATE TABLE Book ( ISBN int, title varchar(30), sold_copies int, price int, publisher varchar(30) ); CREATE TABLE Writes ( SSN int, ISBN int, year int, income int ); INSERT INTO Author VALUES (0, 'Ege', 5, 'Turkey'); INSERT INTO Author VALUES (1, 'Selen', 10, 'Arnavut'); INSERT INTO Author VALUES (2, 'Nira', 3, 'Turkey'); INSERT INTO Author VALUES (3, 'Demir', 4, 'America'); INSERT INTO Author VALUES (4, 'Yağız', 12, 'Germany'); INSERT INTO Author VALUES (5, 'Bahar', 30, 'Turkey'); INSERT INTO Author VALUES (6, 'Eda', 27, 'Russia'); INSERT INTO Author VALUES (7, 'Turgut', 33, 'Turkey'); INSERT INTO Author VALUES (8, 'Atahan', 7, 'Budapeste'); INSERT INTO Author VALUES (9, 'Ata', 62, 'Germany'); INSERT INTO Book VALUES (0, 'Huzursuzluk', 10, 62, 'Springer'); INSERT INTO Book VALUES (1, 'Cehennem', 5, 53, 'Prentice-Hall'); INSERT INTO Book VALUES (2, 'Cennet', 9, 32, 'Springer'); INSERT INTO Book VALUES (3, 'Ataturk', 12, 14, 'Springer'); INSERT INTO Book VALUES (4, 'Erdogan', 13, 15, 'Prentice-Hall'); INSERT INTO Book VALUES (5, 'Camlik', 17, 18, 'Prentice-Hall'); INSERT INTO Book VALUES (6, 'Social Sciences', 19, 25, 'Springer'); INSERT INTO Book VALUES (7, 'Mathematics', 18, 30, 'Prentice-Hall'); INSERT INTO Book VALUES (8, 'Physics', 20, 40, 'Springer'); INSERT INTO Book VALUES (9, 'Computer Sciences', 21, 70, 'Prentice-Hall'); select SSN, name from ( select SSN, name, count(ISBN) as cnt from ((Author inner join Book) natural join Writes) where country = 'Turkey' and year between 2010 and 2020 group by SSN, name having cnt >= 3 ) as T;