60.1K

Verified Solution

Link Copied!

Aliens Aliens Aliens Allens Aliens Aliens Amadeus Amadeus Amadeus Amadeus Amadeus American Beauty American Beauty Rom Mendes American Beauty Rom Mendes Amaian Bau Bon Mana Aliens Aliens Allens Aliens Aliens Aliens s Action Cameron Action Cameron Action Cameron Action Cameron Action Cameron Action Cameron Drama Forman Annie Hall Annie Hall Avatar Name Drama Forman Drama Forman Drama Forman Show titles genre 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 director genre movie rating reviewer Drama Forman Rom Mendes Action Cameron Action Cameron Action Cameron Action Cameron 8 7 8 6 9 0 8 1 7 9 8 0 7 4 7 0 8 1 9 4 Action Cameron 9 5 8 0 96 Action Cameron American Splendor Comedy Springer Berman American Splendor Comedy Springer Borman American Splendor Comedy Springer Berman American Splendor Comedy Springer Berman American Splendor Comedy Springer Berman 8 3 American Splendor Comedy Springer Berman 9 1 American Splendor Comedy Springer Berman American Splendor Comedy Springer Berman Annie Hall Comedy Allen Annie Hall 7 3 9 5 9 8 Comedy Allen Comedy Allen Comedy Allen Adven Cameron 9 6 9 0 8 2 9 0 8 6 9 0 8 1 7 9 8 0 78 8 6 8 5 7 7 7 5 Info Tables Columns Indexes Triggers Views Stored Procedures Functions Grants Events Engine InnoDB InnoDB InnoDB InnoDB InnoDB Version 10 10 10 10 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 F 0 0 0 0 0 0 0 0 0

Answer & Explanation Solved by verified expert

See Answer