SELECT
	CONCAT(c.LASTNAME, ', ', c.FIRSTNAME) AS CUSTOMER,
	possible_invoices.INVOICE_ID,
	FORMAT(possible_invoices.INV_TOTAL, 2) AS INV_TOTAL,
	FORMAT(possible_invoices.ITEMS_TOTAL, 2) AS ITEMS_TOTAL
FROM
	(
	SELECT
		SUM(ii.PRICE) AS ITEMS_TOTAL,
		i.INVOICE_ID,
		i.CUSTOMER_ID,
		i.POSTDATE,
		i.AMOUNT AS INV_TOTAL,
		i.INVTYPE
	FROM
		invoice_items ii
		LEFT JOIN invoices i ON ii.INVOICE_ID = i.INVOICE_ID
	WHERE
		i.INVTYPE = 'DUES'
		AND DATE(i.POSTDATE) >= DATE('2023-04-11')
		AND i.VOIDEDINVOICE = 0
	GROUP BY
		i.INVOICE_ID
	) AS possible_invoices
	LEFT JOIN customers c ON possible_invoices.CUSTOMER_ID = c.CUSTOMER_ID
WHERE
	possible_invoices.INV_TOTAL <> possible_invoices.ITEMS_TOTAL