SQLGiven a list of (date, duration) tuples, how would you filter by time period and calculate summary stats (average, rolling sum)?Was asked at