SQL added 'closed calls in given number of days'

re-usable sql query for finding out number of closed calls in a given number of days