Need Mysql Commands Following Create Query Demonstrate Use Exists Keyword List Actors Id F Q37160669

Need MySQL commands for the following:

1. Create a query to demonstrate use of the EXISTS keyword. Listall the actors (ID, First Name, Last Name) from the actors tablewhose actor ID exists in the film_actor table. Only list those thathave a film ID greater than 400. You must construct your statementlike it was demonstrated to you in the tutorial for Chapter 18.

2. Create a query to demonstrate the use of NOT IN. List allcolumns from the category table where the name equals Comedy andname is not in Drama or Action.

3. Create a query to demonstrate the use of NOT IN and AND. Listall columns

   OR

    

   

   OR