Can you show me the first names of customers who have a rental date on or before 2005-08-23?
select first_name from customer where customer_id in ( select customer_id from rental where rental_date < = '2005-08-23 00:00:00' )
Hmm, I want to know the customer ids who have not rented any films after '2005-08-23 02:06:01' please.
select customer_id from customer where customer_id not in ( select customer_id from rental where rental_date > '2005-08-23 02:06:01' )
Can you just show me the first names of those customers?
select first_name from customer where customer_id not in ( select customer_id from rental where rental_date > '2005-08-23 02:06:01' )