Look at my query for correction

I have a query that deletes records based on a certain time frame, but it seems like the way i'm approaching it doesn't meet expectations.