Hello,

I have trouble coming up with SQL queries that satisfy these 4 questions. I have attached the ERD diagram for your reference. Can you help me out with the queries?

1. List the details for each director that directed any movie in 2010. Show the details for each director only once. Sort the output by director name.
2. List the actor number for the actors that have had at least 2 roles in 2011.
3. List the details for all directors that were born before the year 1960. Sequence the output by oldest to youngest.
4. List the year the oldest Action movie was made.

actor actnumb: INTEGER NOT NULL role Appears in mvnumb: INTEGER NOT NULL (FK) actnumb: INTEGER NOT NULL (FK) actname: CHAR(20) NOT NULL birthplace: CHAR(20) NOT NULL yearbom: INTEGER NOT NULL yeardied: INTEGER NULL myfee: INTEGER NOT NULL "...!!!!!!!!!!!!.........!!!!!!!!!!!!!!!!!!!!!!!!!!!! Features T movie mynumb: INTEGER NOT NULL director dirnumb: INTEGER NOT NULL eos -- dirname: CHAR(20) NOT NULL yearborn: INTEGER NOT NULL yeardied: INTEGER NULL mvtitle: CHAR(30) NOT NULL yearmade: INTEGER NOT NULL mtype: CHAR(10) NOT NULL noms: INTEGER NOT NULL a wrds: INTEGER NOT NULL dirnumb: INTEGER NOT NULL (FK)