Write the SQL queries (select statements) to obtain the following information

1- List of all movies

2-List of all Action movies

3-List of all Comedy movies

4- List of all movies released after Jan 1, 2001

5- List of all directors

6- List of all movies directed and written by the same person

7- Number of Action movies

8- Number of movies released before Jan 1, 2001

9- List of all writers who have written comedy movies released before Jan 1, 2005

10- List of all directors who have directed action movies released after Jan 1, 2005