Report KPI Postgresql

SELECT
	delivery_note.name AS "Delivery Note",
	stock_picking.date_done AS "DN/SJ Date",
	res_partner.id AS "ID Address Name",
	res_partner.display_name AS "Address Name",
	sale_order.date_order AS "Tgl PO/Barang Masuk",
	delivery_note.tanggal AS "Tanggal Kirim",
	CASE
		WHEN
			DATE_PART('month', delivery_note.tanggal::date) - DATE_PART('month', sale_order.date_order::date) = 0
			AND
			DATE_PART('days', delivery_note.tanggal::date) - DATE_PART('days', sale_order.date_order::date) <= 7
		THEN DATE_PART('days', delivery_note.tanggal::date) - DATE_PART('days', sale_order.date_order::date)
		ELSE null
	END AS "Selisih Hari",
	CASE
		WHEN
			DATE_PART('month', delivery_note.tanggal::date) - DATE_PART('month', sale_order.date_order::date) = 0
			AND
			DATE_PART('days', delivery_note.tanggal::date) - DATE_PART('days', sale_order.date_order::date) <= 7
		THEN 'Tercapai'
		ELSE 'Tidak Tercapai'
	END AS "Status"

FROM
	delivery_note

LEFT JOIN
	res_partner ON delivery_note.partner_id = res_partner.id
LEFT JOIN
	stock_picking ON res_partner.id = stock_picking.partner_id
LEFT JOIN
	order_preparation ON delivery_note.prepare_id = order_preparation.id
LEFT JOIN
	sale_order ON order_preparation.sale_id = sale_order.id

WHERE
	delivery_note.state='done'
	AND EXTRACT(YEAR FROM delivery_note.tanggal) = 2015
	AND EXTRACT(MONTH FROM delivery_note.tanggal) = 11
	AND EXTRACT(YEAR FROM sale_order.date_order) = 2015
	AND EXTRACT(MONTH FROM sale_order.date_order) = 11
	--AND res_partner.display_name ILIKE '%FREEPORT INDONESIA, PT%'

--GROUP BY delivery_note.name, stock_picking.date_done, res_partner.display_name, sale_order.date_order, delivery_note.tanggal