The dvd rental company wants to customize their marketing campaigns based on what country they are from. And they now decided to determine a marketing strategy for the customers that live in Brazil (=country)
So, create SQL query that gets the first_name, last_name, email and the country of all the customers from Brazil.
(Hint: Use "customer" and "address" tables to work on this question, with LEFT JOIN).
Expected output is given below.

 

   

Transcribed Image Text:

first name text CLAYTON JOSEPH TAMARA last name text BARBEE JOY NGUYEN email text CLAYTON.BARBEE@sakilacustomer.org JOSEPH JOY@sakilacustomer.org TAMARA.NGUYEN@sakilacustomer.org country text Brazil Brazil Brazil first name text CLAYTON JOSEPH TAMARA last name text BARBEE JOY NGUYEN email text CLAYTON.BARBEE@sakilacustomer.org JOSEPH JOY@sakilacustomer.org TAMARA.NGUYEN@sakilacustomer.org country text Brazil Brazil Brazil

Answer rating: 100% (QA)

To create an SQL query that retrieves the first name last name email and country of all customers fr... View the full answer