SELECT orgs.org_name,
    bldg.building_name,
    SUM(bda.end_meter_black) sum_end_meter_black,
    SUM(bda.begin_meter_black) sum_begin_meter_black,
    SUM(bda.end_meter_black - bda.begin_meter_black) actual_volume, #fy_bk_vol,
    #SUM(bda.projected_volume_black) fy_bk_vol,
    SUM(bda.billed_projected_volume_black) prepaid_bk_vol,
    (SUM(bda.end_meter_black - bda.begin_meter_black) - SUM(bda.billed_projected_volume_black)) reconciled_vol,
    bda.cpc_black,
    SUM(bda.projected_volume_black * bda.cpc_black) fy_bk_costs,
    SUM(bda.billed_projected_volume_black * bda.cpc_black) prepaid_bk_costs            

    FROM billing_data_archive bda
    INNER JOIN machines_current mc ON mc.`SerialNumber` = bda.serial_number
    INNER JOIN buildings bldg ON bda.building_id_ma = bldg.id
    INNER JOIN organization orgs ON bda.org_id_ma = orgs.id

    WHERE bda.billing_gp_id = 73
    AND bda.school_year = 18
    GROUP BY bldg.building_name;




SELECT org.org_name,
    bldg.building_name,?
    SUM(ma.end - ma.begin) fy_bk_vol,        ?
    SUM(bda.billed_projected_volume_black) prepaid_bk_vol,?
    SUM(ma.end - ma.begin) * ma.CostCopy fy_bk_costs,?
    SUM(bda.billed_projected_volume_black) * ma.CostCopy prepaid_bk_costs,    ?
    ?
    SUM(ma.MstrEnd - ma.MstrBegin) fy_col_vol,?
    SUM(bda.billed_projected_volume_color) prepaid_col_vol,?
    SUM(ma.MstrEnd - ma.MstrBegin) * ma.Mstrcpc fy_col_costs,?
    SUM(bda.billed_projected_volume_color) * ma.Mstrcpc prepaid_col_costs, ?
    ma.Mstrcpc,?
    ma.MstrEnd, ma.MstrBegin?
        ?
    FROM Machine_Archive ma?
    INNER JOIN machines_current mc ON mc.`SerialNumber` = ma.SerialNumber AND mc.org_id_ma = ma.org_id_ma?
    INNER JOIN buildings bldg ON ma.building_id_ma = bldg.id?
    INNER JOIN organization org ON ma.org_id_ma = org.id?
    INNER JOIN billing_data_archive bda ON bda.serial_number = ma.SerialNumber AND bda.org_id_ma = ma.org_id_ma?
?
    WHERE org.id = 4     /* ma.billing_gp_id = 73?*/
    AND ma.school_year = 18?
    GROUP BY bldg.building_name;