The question: "List the actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Give the actor name, movie title & year. Order the result by the actor name."
My plaftorm is ACCESS, but I'm typing the SQL myself. Here's what I have so far after 7 hours (really, I'm 50. I want to know this stuff so I can get a job):
SELECT STARNAME,MVTITLE, MVYEAR, (COUNT)BESTM AS BEST_MALE
FROM STAR, MOVSTAR, MOVIE
WHERE STAR.STARNUM = MOVSTAR.STARNUM AND
MOVIE.MVNUM = MOVSTAR.MVNUM AND
BESTM="W" AND SEX="M"
GROUP BY STAR.STARNAME
HAVING (COUNT)BESTM>2
ORDER BY STARNAME