Hello,

I am trying to analyze 56 years of hourly rainfall data.

Right now i have three columns. Date(mm/dd/yyyy), hr(0-23) and hourly Rainfall(inches).

I would like to know the count of rainfall events that exceed 2.4 inches in 24 hrs.

once an event is identified the next event should be identified with a gap of 72 hours.

Any suggestions on how to query this?

Thanks,