Consider the following relations: Movie (Title, Year, Rating, StudioName) Studio (Name, Country, Address) Assume each movie is produced by just one studio, whose name is mentioned in the StudioName attribute of the Movie relation. Attributes Title and Name are primary keys for relations Movie and Studio, respectively. Attribute StudioName is a foreign key from relation Movie to relation Studio. Attribute Rating shows how popular a movie is and its values are between 1-10. The following statistics are available about the relations Movie T(Movie) 24000 V(Movie,StudioName)-800 V(Movie,Rating)-10 Studio T(Studio)- 1000 The following query returns the movies with a rating of 10 produced in each country after 1990. SELECT Country, Title FROM Movie, Studio WHERE Movie.StudioName - Studio.Name and Year > 1990 and Rating -10 Suggest an optimized logical query plan for the above query. Then, estimate the size of each intermediate relation in your query plan. By an intermediate relation, we mean the relation created after each selection or join Consider the following relations: Movie (Title, Year, Rating, StudioName) Studio (Name, Country, Address) Assume each movie is produced by just one studio, whose name is mentioned in the StudioName attribute of the Movie relation. Attributes Title and Name are primary keys for relations Movie and Studio, respectively. Attribute StudioName is a foreign key from relation Movie to relation Studio. Attribute Rating shows how popular a movie is and its values are between 1-10. The following statistics are available about the relations Movie T(Movie) 24000 V(Movie,StudioName)-800 V(Movie,Rating)-10 Studio T(Studio)- 1000 The following query returns the movies with a rating of 10 produced in each country after 1990. SELECT Country, Title FROM Movie, Studio WHERE Movie.StudioName - Studio.Name and Year > 1990 and Rating -10 Suggest an optimized logical query plan for the above query. Then, estimate the size of each intermediate relation in your query plan. By an intermediate relation, we mean the relation created after each selection or join