-- create a table
CREATE TABLE review (
  review_id INTEGER PRIMARY KEY,
  status_id INTEGER
);


CREATE TABLE review_detail (
  detail_id INTEGER PRIMARY KEY,
  review_id INTEGER,
  title TEXT,
  nickname TEXT
);


INSERT INTO review VALUES (1, 2);
INSERT INTO review VALUES (2, 2);
INSERT INTO review VALUES (3, 2);
INSERT INTO review VALUES (4, 2);
INSERT INTO review VALUES (5, 2);


INSERT INTO review_detail VALUES (1, 1, 'Test Title', 'Test nickname');
INSERT INTO review_detail VALUES (2, 2, 'Test Title', 'Test nickname');
INSERT INTO review_detail VALUES (3, 3, 'Test Title', 'Test nickname');
INSERT INTO review_detail VALUES (4, 4, 'Test Title222', 'Test nickname333');
INSERT INTO review_detail VALUES (5, 5, 'Test Title111', 'Test nickname111');


DELETE FROM `review` WHERE `review_id` NOT IN (SELECT max(`review_id`) FROM `review_detail` GROUP BY `title`, `nickname`  HAVING count(*) > 1);


SELECT * FROM `review`;