***MySQL***

I have a database (imdb) that contains 3 tables: movies, actors, cast.

here's a sample of these tables:

movies:

actors:

cast:

1. Which movies had the highest salary average? The column salary is within the cast table.

2. Show the highest salary for each gender.

please note that I'm not allowed to create views.

thank you!!!!!

\begin{tabular}{l|l|l|} \hline [ [ id & full_name & gender \\ \hline 933 & Lewis Abernathy & M \\ \hline 2547 & Andrew Adamson & M \\ \hline 2700 & William Addy & M \\ \hline 2898 & Seth Adkins & M \\ 2925 & Charles Adler & M \\ \hline 3226 & Casey Affleck & M \\ \hline 4306 & Shigekazu Aida & M \\ \hline 4856 & Julliet Akinyi & M \\ \hline 6005 & Henri Alciatore & M \\ \hline 6990 & Dean Alexandrou & M \\ \hline \end{tabular}