Prolog

Hey,

I have a knowledgebase of

movie(untitled_woody_allen_fall_project_2006, 2006).
director(untitled_woody_allen_fall_project_2006, woody_allen).
actor(untitled_woody_allen_fall_project_2006, woody_allen, '').
actor(untitled_woody_allen_fall_project_2006, jody_halse, bouncer).
actor(untitled_woody_allen_fall_project_2006, hugh_jackman, '').
actress(untitled_woody_allen_fall_project_2006, scarlett_johansson, '').
actor(untitled_woody_allen_fall_project_2006, robyn_kerr, '').
actor(untitled_woody_allen_fall_project_2006, kevin_mcnally, mike_tinsley).
actor(untitled_woody_allen_fall_project_2006, ian_mcshane, '').
actor(untitled_woody_allen_fall_project_2006, james_nesbitt, '').
actor(untitled_woody_allen_fall_project_2006, colin_salmon, '').


..
with about 50 other movies as well

How do I find, for example, what actor and director have worked in a movie >n times?

I was thinking

find_actor_director_dup(A,D,n):- len(actor(M,A,_),director(M,D,_))>n.

but I'm that doesn't work and now that I think harder about it it probably shouldn't work...

any ideas?

scarlett_johansson
fapfapfap

DON'T HELP HIM

even a place where I could read up on prolog would be good...

I can't find shit

A month ago, as a part of my war against cretinism and not using what life gives you, I made a resolution not to help people who don't use code tags.

Use Oracle Database 11g Enterprise Edition, problem solved.

?- help(findall).

grep, sed, sort and [spoiler
awk[/spoiler]

>>8
You have been caught failing at KEYBOARD ENTRY

SELECT actor, director FROM movie m, actor a
  WHERE m.actor = a.actor
  LIMIT N

<-- check em dubz

All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy
 All work and no play makes Jack a dull boy