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 : 16:55:46
|
| 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'.please reply as soon as possible.thank you |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-17 : 17:01:21
|
| How about answering your own homework questions so you can at least feel good about doing the work yourself? |
 |
|
|
|
|
|
queries in SQL