SQL Basics

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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

Evaluate responses using AI:

OFF

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.

Evaluate responses using AI:

OFF