Need help with SQL Stored procedure to populate Datasets for an SSRS report

Job ID: 31659209

Budget: $10 – $30 CAD

I've got a bunch of tables from which I need to create a stored procedure to populate an SSRS report. It needs information sliced up into buckets with a total fields 2 columns.

Sample is below and I can provide raw data samples as well.