Dates between two columns

Database
Enthusiast

Dates between two columns

Hi There

I got some problem while i am selecting the data between two coulmns please help me out this.Underlined one i am getting problem please help me out this.

SELECT AL2.Pod_Id, AL2.Internet_Pod_Id, AL2.Sku_Id FROM
EDW_VIEWS.PRES_OFR_STAT_HIST AL1 LEFT OUTER JOIN EDW_VIEWS.PRES_OFR_MEDIA_SET_SKU AL2 ON (AL1.Pod_Id=AL2.Pod_Id )
WHERE AND AL1.Pres_Ofr_Stat_Cd='A'
AND NOT EXISTS (
SELECT * FROM EDW_VIEWS.TRANSACTIONS AL3 WHERE AL3.SOLD_SKU_ID = AL2.SKU_ID
AND AL3.SALES_TRANSACTION_CHANNEL_CD=1 AND AL3.DELIVERY_METHOD_ID=3 )
order by AL1.POD_ID,AL2.SKU_ID

Thanks
h