Hi,

I have the following ADDRESS table:

Code:
---------+---------+----
EFF_DATE    POSTAL_CODE
---------+---------+----
2015-08-12  X3H2N3
2012-12-24  X4C8C2
1999-07-02  X4S2B5
1995-05-01  X2R2A1
1994-06-03  X2R3B6
1991-11-28  X3H4X5

EFF_DATE is the start date. The table doesn't contain END_DATE.
In this example, AA lived at X4S2B5 from 1999-07-02 to 2012-12-24.

I need to write a query that will return the postal code of where AA lived between 2000 and 2003. It should return X4S2B5 because 2000-2003 falls between 1999-07-02 and 2012-12-24.

Is this possible with sql?

Thanks