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 average fee paid for actors in role in an Action movie in 2010.
2. List the number of movies made for each movie type. Order the output by highest count to lowest.
3. List the movie types that have had between 2 and 4 movies made between 2010 and 2012.
4. List the details for an actor who has had a role in an Action movie that has received more than 3 nominations or 2 awards. Only show each actors details once and sequence by actor name.

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)