I have three columns: customerID, transactionDate, and lastVisitDate. CustomerID is an int, and the other two fields are of the datatype timestamp. I would like to know how I can select the customers on a given day (the transactionDate) who have been in the store no more than 90 days ago...so 90 days or less. I should mention that I'm doing this in hive.