[Solved] 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 from the category table where the name is not in Comedyor Action and category ID is 3 or 4.

4. Create a query to demonstrate the use of a CASE expression. Listthe film ID and title from the film table. Include a third columnnamed RatingText. RatingText should display Parental GuidanceSuggested when the rating on the table is PG, General Audienceswhen G, and Restricted when R. Otherwise, RatingText should displayNo Match Found if it does not match any of this criteria. Only showthe rows where the film ID is less than 8.

5. Create a query to demonstrate the use of a CASE expression ina WHERE clause. List all customers who areActive. Active issignified by a 1 in the active column of the customer table.

Here are the table names:

200BASE TABLE 603 BASE TABLE BASE TABLE 600 BASE TABLE 109BASE TABLE 599 BASE TABLE 1000 BASE TABLE 5462 BASE TABLE film category 1000 BASE TABLE 1000 BASE TABLE 4581 BASE TABLE BASE TABLE 16086 BASE TABLE 16005 BASE TABLE BASE TABLE BASE TABLE actor address category C1 country customer film film actor 16 film text inventory language payment rental staff store Show transcribed image text 200BASE TABLE 603 BASE TABLE BASE TABLE 600 BASE TABLE 109BASE TABLE 599 BASE TABLE 1000 BASE TABLE 5462 BASE TABLE film category 1000 BASE TABLE 1000 BASE TABLE 4581 BASE TABLE BASE TABLE 16086 BASE TABLE 16005 BASE TABLE BASE TABLE BASE TABLE actor address category C1 country customer film film actor 16 film text inventory language payment rental staff store

Expert Answer

---

Answer to Need MySQL commands for the following: Create a query to demonstrate use of the EXISTS keyword. List all the actors (ID,… . . .