Queries in use

SELECt dpt.dept_name, bd.billing_id, bd.dept_id_ma, dpt.dept_name,
bd.projected_volume_black proj_vol_blk, bd.billed_projected_volume_black bill_proj_vol_blk,
bd.projected_volume_color proj_vol_col, bd.billed_projected_volume_color bill_proj_vol_col,
bd.cpc_black, bd.vendor_cpc_black, bd.cpc_color,bd.vendor_cpc_color,
bd.client_black_charge, bd.client_color_charge, bd.vendor_black_charge, bd.vendor_color_charge
FROM billing_data bd
INNER JOIN department dpt ON dpt.id = bd.dept_id_ma
WHERE bd.billing_id = 36

GROUP BY bd.dept_id_ma
ORDER BY dpt.dept_name;