Nested Aggregate SQL Query by rtsfree

I want to create a single view that returns JobID, TotalBillableAmount, TotalBilled and TotalAlreadyUnbilled. Part1 subquery returns total billing for that job, regardless of billdate. Part2 returns… (Budget: $30-$250 USD, Jobs: SQL)