SELECT	shipstate,
		Max(shipcountry)   AS Country,
		Sum(paymentamount) AS Sales
FROM	`orders`
WHERE	orderdate BETWEEN '2024-01-01' AND '2024-12-31'
		AND orderstatus != 'Cancelled'
GROUP	BY shipstate