By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,286 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,286 IT Pros & Developers. It's quick & easy.

Wha is the SQL Query for showing the top-rated films involving people (in any role)

P: 3
What are the top-rated films involving people (in any role) who have
received a Best Actor Oscar? For ‘top-rated’ assume a film rating of at
least 8 out of 10.



For each film, what is the average regional box office taking? Note that
the Box Office Takings only has entries for weeks where some tickets
were actually sold.

Which film failed to make any money in its first week of release?

Which films has the actor who has received the most awards appeared
in?

Who is the most awarded female director from outside of the US?

For the person in f., where did the films that they direct make the most
money? Ensure that you are using the total takings in each region across
all of the films they directed.

Tables
Nationality(NationalityID, NationalityDescription)
Film(FilmID, FilmTitle,Release Date, GenreID, StudioID, FilRating, Plot)
Role(RoleID, RoleTypeID, PersonID)
Person(PersonID, FName, Sname, NationalityID, GenderID, GenderDescription)
Gender(GenderID, GDescrip)
Studio(StudioID, SType)
BoxOfficeTakings(TakingID, TimePeriodID,FilmID,TakingsMoney)
Award(AwardID, RoleID, AwardDEscription, AwardType, YearAwarded)
TimePeriod(TimePeriod, WeekNumber, WeekStartedDate, WeekEndDate, Year)
Region(RegionID, RegionName)
AwardType(AwardTypeID, AwardTypeDescription)
AwardCategory(AwardCategoryID, AwardTypeDescription)
May 14 '10 #1
Share this Question
Share on Google+
1 Reply


dlite922
Expert 100+
P: 1,584
This is a question from a homework for a class exercise.

You need to understand the basics of SQL queries. You should be able to do this on your own.

Write it on your own then if it doesn't work, ask in the database forum. This is a PHP forum.






Dan
May 14 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.