47 Using the Customer and the Address table (you will need to

Using the Customer and the Address table (you will need to Join the… Using the Customer and the Address table (you will need to Join the tables), list the customer_id, first_name, last_name, address, district, city_id, postal_code, phone, and email for those customers that live in California. Join on the address_id from both tables. Order by last_name then first_name Prepare  and execute each of the queries listed using the “sakila” database in MySQL. The schema shown below is the structure of the SAKILA database.Computer Science Engineering & Technology MYSQL