CREATE TABLE inventory (inventory_id DECIMAL, film_id DECIMAL, store_id DECIMAL, last_update TIME)
CREATE TABLE category (category_id DECIMAL, name TEXT, last_update TIME)
CREATE TABLE customer (customer_id DECIMAL, store_id DECIMAL, first_name TEXT, last_name TEXT, email TEXT, address_id DECIMAL, active BOOLEAN, create_date TIME, last_update TIME)
CREATE TABLE film_category (film_id DECIMAL, category_id DECIMAL, last_update TIME)
CREATE TABLE actor (actor_id DECIMAL, first_name TEXT, last_name TEXT, last_update TIME)
CREATE TABLE film_actor (actor_id DECIMAL, film_id DECIMAL, last_update TIME)
CREATE TABLE staff (staff_id DECIMAL, first_name TEXT, last_name TEXT, address_id DECIMAL, picture others, email TEXT, store_id DECIMAL, active BOOLEAN, username TEXT, password TEXT, last_update TIME)
CREATE TABLE city (city_id DECIMAL, city TEXT, country_id DECIMAL, last_update TIME)
CREATE TABLE country (country_id DECIMAL, country TEXT, last_update TIME)
CREATE TABLE film (film_id DECIMAL, title TEXT, description TEXT, release_year TIME, language_id DECIMAL, original_language_id DECIMAL, rental_duration DECIMAL, rental_rate DECIMAL, length DECIMAL, replacement_cost DECIMAL, rating TEXT, special_features TEXT, last_update TIME)
CREATE TABLE rental (rental_id DECIMAL, rental_date TIME, inventory_id DECIMAL, customer_id DECIMAL, return_date TIME, staff_id DECIMAL, last_update TIME)
CREATE TABLE language (language_id DECIMAL, name TEXT, last_update TIME)
CREATE TABLE store (store_id DECIMAL, manager_staff_id DECIMAL, address_id DECIMAL, last_update TIME)
CREATE TABLE address (address_id DECIMAL, address TEXT, address2 TEXT, district TEXT, city_id DECIMAL, postal_code TEXT, phone TEXT, last_update TIME)
CREATE TABLE payment (payment_id DECIMAL, customer_id DECIMAL, staff_id DECIMAL, rental_id DECIMAL, amount DECIMAL, payment_date TIME, last_update TIME)
CREATE TABLE film_text (film_id DECIMAL, title TEXT, description TEXT)

Where does the customer with the first name Linda live? And what is her email?
SELECT T2.address, T1.email FROM customer AS T1 JOIN address AS T2 ON T2.address_id = T1.address_id WHERE T1.first_name = 'LINDA'
SELECT "T2"."address", "T1"."email" FROM "customer" AS "T1" JOIN "address" AS "T2" ON "T1"."address_id" = "T2"."address_id" WHERE "T1"."first_name" = 'LINDA'