Whats wrong with this SQL Query

[thomasjonesmona]

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.

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

SELECT     Person.PersonID, Person.FirstName, Person.Surname, AwardType.AwardTypeDescription
FROM         Person CROSS JOIN
                      AwardType
WHERE     (AwardType.AwardTypeDescription = 'Oscar')
GROUP BY Person.PersonID, Person.FirstName, Person.Surname, AwardType.AwardTypeDescription

tables

RoleType(RoleTypeID, RoleTypeDescription)
Film(FilmID, FilmTitle,Release Date, GenreID, StudioID, FilRating, Plot)
Role(RoleID, RoleTypeID, PersonID)
Person(PersonID, FName, Sname, NationalityID, GenderID, GenderDescription)
Award(AwardID, RoleID, AwardDEscription, AwardType, YearAwarded)
AwardType(AwardTypeID, AwardTypeDescription)
AwardCategory(AwardCategoryID, AwardTypeDescription)

[ck9663]

Looks like you don't have a link between Film and Person. You must have a table with the filmId and all the cast on it via personid.

Good Luck!!!

~~ CK