May I ask the SQL code as follows?

The relational database moviedb has the following database schema:

Movie(title, production year, country, run time, major genre) primary key : {title, production year}

Person(id, first name, last name, year born) primary key : {id}

Award(award name, institution, country) primary key : {award name}

Restriction Category(description, country) primary key : {description, country}

Director(id, title, production year) primary key : {title, production year} foreign keys : [title, production year] Movie[title, production year] [id] Person[id]

Writer(id, title, production year, credits) primary key : {id, title, production year} foreign keys : [title, production year] Movie[title, production year] [id] Person[id]

Crew(id, title, production year, contribution) primary key : {id, title, production year} foreign keys : [title, production year] Movie[title, production year] [id] Person[id]

Scene(title, production year, scene no, description) primary key : {title, production year, scene no} foreign keys : [title, production year] Movie[title, production year]

Role(id, title, production year, description, credits) primary key : {title, production year, description} foreign keys : [title, production year] Movie[title, production year] [id] Person[id]

Restriction(title, production year, description, country) primary key : {title, production year, description, country} foreign keys : [title, production year] Movie[title, production year] [description, country] Restriction Category[description, country]

Appearance(title, production year, description, scene no) primary key : {title, production year, description, scene no} foreign keys : [title, production year, scene no]Scene[title, production year, scene no] [title, production year, description]Role[title, production year, description]

Movie Award(title, production year, award name, year of award,category, result) primary key : {title, production year, award name, year of award, category} foreign keys : [title, production year] Movie[title, production year] [award name] Award[award name]

Crew Award(id, title, production year, award name, year of award, category, result) primary key : {id, title, production year, award name, year of award, category} foreign keys : [id, title, production year] Crew[id, title, production year] [award name] Award[award name]

Director Award(title, production year, award name, year of award, category, result) primary key : {title, production year, award name, year of award, category} foreign keys : [title, production year] Director[title, production year] [award name] Award[award name]

Writer Award(id, title, production year, award name, year of award, category, result) primary key : {id, title, production year, award name, year of award, category} foreign keys : [id, title, production year] Writer[id, title, production year] [award name] Award[award name]

Actor Award(title, production year, description, award name, year of award,category,result) primary key : {title, production year, description, award name, year of award, category} foreign keys : [award name] Award[award name] [title,production year,description]Role[title,production year,description]

There are five different categories of awards: movie awards, crew awards, director awards, writer awards and actor awards. A movie can only win an award after being nominated for the award. Your task is to answer the following questions using SQL queries. For each question, your answer must be a single SQL query that may contain subqueries, and you must write your answers into the template file myqueries.sql.

1.9 Who has/have won a most recent writer award? List their id(s). (1.5 Mark)

1.10 Who have won both writer and director awards for the same movie? Provide their ids, and the titles and production years of the corresponding movies. (1.5 Mark)

1.11 Who have been nominated for an actor award at least twice but never won? List their ids, the first and last names, and order them in the ascending order of their last names. (2 Mark)

1.12 Which crew members have worked on a movie that has won the greatest number of movie awards? Give the ids of the crew members. (2 Mark)