Have an account?
Skip to Content
Build your own quiz
Suggestions for you
7 questions
Show Answers
See Preview
- 1. Open Ended
Refer to the image. Provide the necessary sql code to generate this schema.
- 2. Open Ended
Refer to this schema. Provide the query to list all the directors first name and last name;
- 3. Open Ended
Refer to the schema. Provide the query that lists for each movie name, the corresponding actors names.
- 4. Open Ended
Refer to the schema. Provide the necessary query to list how many actors have no movies.
- 5. Open Ended
Refer to the schema. Provide the query to insert 2 new directors;
- 6. Open Ended
Refer to the schema. Provide the query that provides the list of unique first names of actors.
- 7. Open Ended
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.
- Answer choicesTagsAnswer choicesTags