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

[thomasjonesmona]

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(Nat ionalityID, NationalityDesc ription)
Film(FilmID, FilmTitle,Relea se Date, GenreID, StudioID, FilRating, Plot)
Role(RoleID, RoleTypeID, PersonID)
Person(PersonID , FName, Sname, NationalityID, GenderID, GenderDescripti on)
Gender(GenderID , GDescrip)
Studio(StudioID , SType)
BoxOfficeTaking s(TakingID, TimePeriodID,Fi lmID,TakingsMon ey)
Award(AwardID, RoleID, AwardDEscriptio n, AwardType, YearAwarded)
TimePeriod(Time Period, WeekNumber, WeekStartedDate , WeekEndDate, Year)
Region(RegionID , RegionName)
AwardType(Award TypeID, AwardTypeDescri ption)
AwardCategory(A wardCategoryID, AwardTypeDescri ption)

[dlite922]

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