Write

write a SQL query to show the movie title and its cast details like name of the person, gender, character name, cast order.

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ country } \\ \hline PK & country_id \\ & country_iso_code \\ & country_name \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ language } \\ \hline PK & language_id \\ & \( \begin{array}{l}\text { language_code } \\ \text { language_name }\end{array} \) \\ \hline \end{tabular}