50.1K

Verified Solution

Link Copied!

live Action Cameron Action Cameron Action Cameron Action Cameron Action Cameron Action Cameron Drama Forman Drama Forman Drama Forman Drama Forman Amadeus Drama Forman American Beauty Rom Mendes American Beauty Hom Mendes American Beauty Rom Mendos Aliens Aliens Aliens Aliens Aliens Aliens Amadeus Amadeus Amadeus Amadeus Alens Alons Alens Aliens Show titles gente director last name and rating for all movies where 1 rating is average rating of all movies and 2 do not display movies from director Forman or romance movies Use a subquery in the Where clause Order by title SCREENSHOT Aliens Alons Annie Hall Annie Hall Annie Hall Avatar Name Action Cameron Action Cameron Action Cameron 9 0 Action Cameron 8 1 Action Cameron 7 9 8 0 7 8 9 5 Action Cameron American Splendor Comedy Springer Berman American Splendor Comedy Springer Berman American Splendor Comedy Springer Berman 8 0 American Splendor Comedy Springer Barman 9 5 American Splendor Comedy Springer Berman 83 American Splendor Comedy Springer Berman 9 1 American Splendor Comedy Springer Berman 7 3 American Splendor Comedy Springer Berman Annie Hall Comedy Allen 9 5 9 8 86 director genre movie rating reviewer 8 7 8 6 9 0 8 1 7 9 8 0 74 7 0 Comedy Allen Comedy Allen Comedy Allen Adven Cameron 8 1 9 4 9 6 9 0 8 2 9 0 8 7 8 6 8 5 7 7 7 5 Info Tables Columns Indexes Triggers Views Stored Procedures Functions Grants Events Engine InnoDB InnoDB 10 InnoDB 10 InnoDB 10 InnoDB 10 Version 10 Row Format Dynamic Dynamic Dynamic Dynamic Dynamic Rows 32 13 35 366 29 Avg Row Length 512 1260 468 44 564 Data Length 16 0 KiB 16 0 KiB 16 0 KIB 16 0 KIB 16 0 KIB Max Data Length 0 0 bytes 0 0 bytes 0 0 bytes 0 0 bytes 0 0 bytes Index Length 0 0 bytes 0 0 bytes 32 0 KiB 16 0 KIB 0 0 bytes Data Fri 0 0 0 0 0 0 0 0 0 0

Answer & Explanation Solved by verified expert

See Answer