SELECT *
--DISTINCT(EXTRACT(YEAR FROM A.INVOICEDATE)) YEAR,
--EXTRACT(MONTH FROM A.INVOICEDATE) MONTH,
--SUM(A.TotalNetValue) VALUE_HEADER,
--SUM(B.NetValue) VALUE_DETAIL
FROM `consumption_common_data_model.vwInvoiceHeader` A
inner join `consumption_common_data_model.vwInvoiceDetail` B
ON A.InvoiceID = B.InvoiceID AND A.DivisionID = "12"
WHERE EXTRACT(YEAR FROM A.INVOICEDATE) = 2023
AND EXTRACT(MONTH FROM A.INVOICEDATE) = 11
--WHERE A.DivisionID = "11"
--GROUP BY YEAR, MONTH
--ORDER BY YEAR, MONTH;