Show me all the dates between 1989-09-03 and 2007-12-25 that invoice number was created.
select invoice_date from invoices where invoice_date > "1989-09-03" and invoice_date < "2007-12-25"
Sorry, I meant dates before 1989-09-03 and after 2007-12-25.
select invoice_date from invoices where invoice_date < "1989-09-03" or invoice_date > "2007-12-25"
Now show me their invoice numbers.
select invoice_number from invoices where invoice_date < "1989-09-03" or invoice_date > "2007-12-25"