Using the MySQL SAKILA Database, write a SQL statement in twoways to list the Film Titles and Category Names of all the filmsstarring Lucile Dee. Write the Query as a JOIN and as aSUBQUERY
* film_category film_id SMALLINT category_id TINYINT last update TIMESTAMP Indexes category category_id TINYINT name VARCHAR(25) last_update TIMESTAMP Indexes U film + LP language language_id TINYINT name CHAR(20) last_update TIMESTAMP Indexes — actor actor_id SMALLINT first_name VARCHAR(45) last_name VARCHAR(45) last_update TIMESTAMP Indexes H – – – – film_id SMALLINT title VARCHAR(255) description TEXT release_year YEAR language_id TINYINT original_language_id TINYINT rental_duration TINYINT > rental_rate DECIMAL (4,2) length SMALLINT replacement_cost DECIMAL(5,2) L rating ENUM…) special_features SET(…) last_update TIMESTAMP I Indexes Triggers – * film actor actor_id SMALLINT film_id SMALLINT last_update TIMESTAMP Indexes I— — – inventory inventory_id MEDIUMINT film id SMALLINT store_id TINYINT last_update TIMESTAMP Indexes – – – – – – -H L film_text film_id SMALLINT title VARCHAR(255) description TEXT Indexes Movie database Show transcribed image text * film_category film_id SMALLINT category_id TINYINT last update TIMESTAMP Indexes category category_id TINYINT name VARCHAR(25) last_update TIMESTAMP Indexes U film + LP language language_id TINYINT name CHAR(20) last_update TIMESTAMP Indexes — actor actor_id SMALLINT first_name VARCHAR(45) last_name VARCHAR(45) last_update TIMESTAMP Indexes H – – – – film_id SMALLINT title VARCHAR(255) description TEXT release_year YEAR language_id TINYINT original_language_id TINYINT rental_duration TINYINT > rental_rate DECIMAL (4,2) length SMALLINT replacement_cost DECIMAL(5,2) L rating ENUM…) special_features SET(…) last_update TIMESTAMP I Indexes Triggers – * film actor actor_id SMALLINT film_id SMALLINT last_update TIMESTAMP Indexes I— — – inventory inventory_id MEDIUMINT film id SMALLINT store_id TINYINT last_update TIMESTAMP Indexes – – – – – – -H L film_text film_id SMALLINT title VARCHAR(255) description TEXT Indexes Movie database
Expert Answer
Answer to Using the MySQL SAKILA Database, write a SQL statement in two ways to list the Film Titles and Category Names of all the…