SQL Queries in MySQL

This is using the Sakila Sample database which can download here: https://dev.mysql.com/doc/sakila/en/sakila-installation.html"

https://dev.mysql.com/doc/sakila/en

Write a query that produces the first name, last name, address, district and postal code for all customers. (append to customers the information from address table) (LEFT JOIN)

Write a query that produces address, district, city for all addresses. (RIGHT JOIN)

Write a query that produces address, district, city, country for all Cities. Attach to the list of Cities every country and address.