Sorry I could not able to open your document. Anyway I think the approach should be as below:
first extraction done without any aggregation (e.g sum()) function:
SQL SELECT *
Next do the necessary aggregation and/or transformation over the above resident table like:
Sum(if (Date([Maturity])-Date([CutoffDate]) >=-30, Amount,0)) As '<=30d',
Sum(if (Date([Maturity])-Date([CutoffDate]) >=-90,Amount,0)) As '30d><=90d'
Group By ......;