Write down the email addresses of active customers who rented between 5/25/2005 at 7:37:47 PM and 5/26/2005 at 10:06:49 AM.
email address refers to email; active refers to active = 1; between 5/25/2005 at 7:37:47 PM and 5/26/2005 at 10:06:49 AM refers to rental_date between '2005-5-25 07:37:47' and '2005-5-26 10:06:49'
SELECT T2.email FROM rental AS T1 INNER JOIN customer AS T2 ON T1.customer_id = T2.customer_id WHERE T1.rental_date BETWEEN '2005-5-25 07:37:47' AND '2005-5-26 10:06:49' AND T2.active = 1
database name:db_id movie_3
film_text table film_text Cols: film id dtype integer, title dtype text, description dtype text, 
actor table actor Cols: actor id dtype integer, first name dtype text, last name dtype text, last update dtype datetime, 
address table address Cols: address id dtype integer, address dtype text, address 2 dtype text, district dtype text, city_id dtype integer, postal code dtype text, phone dtype text, last update dtype datetime, 
category table category Cols: category id dtype integer, name dtype text, last update dtype datetime, 
city table city Cols: city id dtype integer, city dtype text, country id dtype integer, last update dtype datetime, 
country table country Cols: country id dtype integer, the name of the country dtype text, last update dtype datetime, 
customer table customer Cols: country id dtype integer, store id dtype integer, first name dtype text, last name dtype text, email dtype text, address id dtype integer, active dtype integer, create date dtype datetime, last update dtype datetime, 
film table film Cols: film id dtype integer, title dtype text, description dtype text, release year dtype text, language id dtype integer, original language id dtype integer, rental duration dtype integer, rental rate dtype real, length dtype integer, replacement cost dtype real, rating dtype text, special features dtype text, last update dtype datetime, 
film_actor table film_actor Cols: actor id dtype integer, film id dtype integer, last update dtype datetime, 
film_category table film_category Cols: film id dtype integer, category id dtype integer, last update dtype datetime, 
inventory table inventory Cols: inventory id dtype integer, film id dtype integer, store id dtype integer, last update dtype datetime, 
language table language Cols: language id dtype integer, name dtype text, last update dtype datetime, 
payment table payment Cols: payment id dtype integer, customer id dtype integer, staff id dtype integer, rental id dtype integer, amount dtype real, payment date dtype datetime, last update dtype datetime, 
rental table rental Cols: rental id dtype integer, rental date dtype datetime, inventory id dtype integer, customer id dtype integer, return date dtype datetime, staff id dtype integer, last update dtype datetime, 
staff table staff Cols: staff id dtype integer, first name dtype text, last name dtype text, address id dtype integer, picture of the staff dtype blob, email of the staff dtype text, store id dtype integer, active dtype integer, username dtype text, password dtype text, last update dtype datetime, 
store table store Cols: store id dtype integer, manager staff id dtype integer, address id dtype integer, last update dtype datetime, 
