SELECT serial_number, cpc_black, cpc_color, projected_volume_black, billed_projected_volume_black, projected_volume_color, billed_projected_volume_color, billing_gp_id, billing_cycle_name, billing_type, vendor_id

FROM billing_data_archive bda
INNER JOIN lkp_billing_cycle lkp ON lkp.billing_cycle_id = bda.billing_cycle
WHERE serial_number = 'A2X1017013204'
AND school_year = 21
#AND billing_cycle != 10
AND billing_type = "Client";

SELECT SerialNumber, vendor_id, Anticipated, ProjColorVol, SUM(End - Begin) tot_vols_blk, SUM(MstrEnd - MstrBegin) tot_vols_col, CostCopy, NewCostCopy, Mstrcpc, NewColorCPC, Black_Vendor_cpc, Color_Vendor_cpc
FROM current_devices WHERE SerialNumber = 'A2X1017013204'