Answered You can hire a professional tutor to get the answer.
ACCESS 2007 "The question: "List the actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best...
ACCESS 2007"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_MALEFROM STAR, MOVSTAR, MOVIEWHERE STAR.STARNUM = MOVSTAR.STARNUM ANDMOVIE.MVNUM = MOVSTAR.MVNUM AND BESTM="W" AND SEX="M"GROUP BY STAR.STARNAMEHAVING (COUNT)BESTM>2ORDER BY STARNAME
