User Profile

thomasjonesmona · May 15 '10, 02:01 AM

I am trying to get 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.

Code:

SELECT     FilmID, FilmTitle, FilmRating
FROM         Film
Where
	FilmRating > 7.9
GROUP BY FilmID, FilmTitle, FilmRating

Code:

SELECT     Person.PersonID, Person.FirstName, Person.Surname, AwardType.AwardTypeDescription

...

thomasjonesmona · May 14 '10, 08:50 PM

Error message is Msg 130, Level 15, State 1, Line 1
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

Code:

SELECT     Film.FilmTitle, Person.FirstName
FROM         Person INNER JOIN
                      Role ON Person.PersonID = Role.PersonID INNER JOIN
                      Film ON Role.FilmID = Film.FilmID
WHERE Film.FilmID IN 
(
SELECT

...

thomasjonesmona · May 14 '10, 04:19 PM

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...

User Profile

Profile Sidebar

Whats wrong with this SQL Query

Whats wrong with this SQL Query?

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