-- create a table
CREATE TABLE ActorDirector (
  actor_id INTEGER,
  director_id INTEGER,
  timestamp INTEGER,
 CONSTRAINT PK_timestamp PRIMARY KEY (timestamp)
);
-- insert some values
INSERT INTO ActorDirector VALUES (1, 1, 0);
INSERT INTO ActorDirector VALUES (1, 1, 1);
INSERT INTO ActorDirector VALUES (1, 1, 2);
INSERT INTO ActorDirector VALUES (1, 2, 3);
INSERT INTO ActorDirector VALUES (1, 2, 4);
INSERT INTO ActorDirector VALUES (2, 1, 5);
INSERT INTO ActorDirector VALUES (2, 1, 6);

-- fetch some values
-- SELECT Count(*) FROM ActorDirector WHERE actor_id = director_id
-- SELECT actor_id, director_id FROM ActorDirector WHERE (SELECT Count(*) FROM ActorDirector WHERE actor_id = director_id) >= 3;
SELECT actor_id, director_id FROM ActorDirector WHERE (SELECT Count(*) FROM ActorDirector WHERE actor_id = director_id) >= 3;