Using the MySQL Sakila Database list the first name, last name,and country name of all the inactive customers.
country country_id SMALLINT country VARCHAR(50) last_update TIMESTAMP Indexes city city_id SMALLINT city VARCHAR(50) country_id SMALLINT last_update TIMESTAMP Indexes customer customer_id SMALLINT store_id TINYINT first name VARCHAR(45) last_name VARCHAR(45) address —K2 email VARCHAR(50) L address_id SMALLINT address VARCHAR(50) – – – – address_id SMALLINT active BOOLEAN create_date DATETIME O last_update TIMESTAMP Indexes – – address2 VARCHAR(50) district VARCHAR(20) city_id SMALLINT postal_code VARCHAR(10) ophone VARCHAR(20) last_update TIMESTAMP Indexes – – – – – — – — Show transcribed image text country country_id SMALLINT country VARCHAR(50) last_update TIMESTAMP Indexes city city_id SMALLINT city VARCHAR(50) country_id SMALLINT last_update TIMESTAMP Indexes customer customer_id SMALLINT store_id TINYINT first name VARCHAR(45) last_name VARCHAR(45) address —K2 email VARCHAR(50) L address_id SMALLINT address VARCHAR(50) – – – – address_id SMALLINT active BOOLEAN create_date DATETIME O last_update TIMESTAMP Indexes – – address2 VARCHAR(50) district VARCHAR(20) city_id SMALLINT postal_code VARCHAR(10) ophone VARCHAR(20) last_update TIMESTAMP Indexes – – – – – — – —
Expert Answer
Answer to Using the MySQL Sakila Database list the first name, last name, and country name of all the inactive customers….