Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohamedmohamedmohamed
Starting Member
3 Posts |
 Posted - 2009-03-17 : 17:05:02
|
| The tables are:actors(actorid, name, sex)movies(movieid, title, year)directors(directorid, name)movie2actors(movieid, actorid)movies2directors(movieid, directorid)ratings(movieid, rank).Please answer these in a SQL, the following questionsShow the names of all actors who have worked in movies with a rank in the top 10 inclusive. Show the movie titles worked in and rank. Sort in descending order of rank.and other question, show the names of all actors who have not worked with director 'paul greengrass'.This is not homework. I just really want to get ideas. Please helpplease reply as soon as possible.thank you |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
mohamedmohamedmohamed
Starting Member
3 Posts |
Posted - 2009-03-17 : 17:36:30
|
| I am generously seeking help from the people to answer my questions, I am not cheating or something, I just want to learn new things, thats my aim. It is neither a homework nor coursework. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-17 : 17:47:33
|
| My apologies. Do you have any code that you've tried yet? Can you post it? It's better to at least take a shot at it first. |
|
|
|
|
|
|
|
|
queries in SQL