SQL Basics

Refer to the image. Provide the necessary sql code to generate this schema.

Refer to this schema. Provide the query to list all the directors first name and last name;

Refer to the schema. Provide the query that lists for each movie name, the corresponding actors names.

Refer to the schema. Provide the necessary query to list how many actors have no movies.

Refer to the schema. Provide the query to insert 2 new directors;

Refer to the schema. Provide the query that provides the list of unique first names of actors.

Refer to the image. Create the necessary sql code so that every time a new actor is created, a new record is inserted in the audit gender table with the matching gender type and actor id.