SQL Queries in MySQL This is using the Sakila Sample database which can download
ID: 3932701 • Letter: S
Question
SQL Queries in MySQLThis is using the Sakila Sample database which can download here: https://dev.mysql.com/doc/sakila/en
Write a query that produce the last name and email address of every customer who has rented a film starring NICK WAHLBERG or MATTHEW JOHANSSON or RITA REYNOLDS (we don’t want to have duplicate rows returned for our query – there is a keyword you might need to use).
**Note that you will be performing a query on multiple tables**
SQL Queries in MySQL
This is using the Sakila Sample database which can download here: https://dev.mysql.com/doc/sakila/en
Write a query that produce the last name and email address of every customer who has rented a film starring NICK WAHLBERG or MATTHEW JOHANSSON or RITA REYNOLDS (we don’t want to have duplicate rows returned for our query – there is a keyword you might need to use).
**Note that you will be performing a query on multiple tables**
SQL Queries in MySQL
This is using the Sakila Sample database which can download here: https://dev.mysql.com/doc/sakila/en
Write a query that produce the last name and email address of every customer who has rented a film starring NICK WAHLBERG or MATTHEW JOHANSSON or RITA REYNOLDS (we don’t want to have duplicate rows returned for our query – there is a keyword you might need to use).
**Note that you will be performing a query on multiple tables**
Explanation / Answer
select distinct customer.last_name,customer.email from customer
inner join inventory on customer.store_id = inventory.store_id
inner join film_actor on inventory.film_id = film_actor .film_id
inner join actor on film_actor.actor_id = actor.actor_id
where actor.first_name = 'NICK' and actor.last_name ='WAHLBERG ' or actor.first_name = 'MATTHEW' and actor.last_name = 'JOHANSSON' or actor.first_name = 'RITA and actor.last_name = 'REYNOLDS';
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.