Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

write SQL queries Find the first_name and last_name of all actors who have never been in a Sci-Fi film. Order by the actor_id in ascending

write SQL queries

  1. Find the first_name and last_name of all actors who have never been in a Sci-Fi film.

    Order by the actor_id in ascending order.

  2. Find the film_title of all films which feature both KIRSTEN PALTROW and WARREN NOLTEOrder the results by film_title in descending order. Warning: this is a tricky one and while the syntax is all things you know, you have to think a bit oustide the box to figure out how to get a table that shows pairs of actors in movies.

image text in transcribed

film film_id title description release_year language_id original_language_i rental_duration rental_rate length replacement_cost category category_id name last_update language language_id name last_update film_category film_id category_id last_update actor actor_id first_name last_name last_update actor id last_update film_id film_actor

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

It can be physically harmful.

Answered: 1 week ago

Question

Organizing Your Speech Points

Answered: 1 week ago