Query Quotation By Group

SELECT
	rfq.group AS group,
	COUNT(CASE WHEN status = 'win' THEN status END) AS win
	, COUNT(CASE WHEN status = 'lost' THEN status END) AS lost
	, COUNT(CASE WHEN status = 'on process' THEN status END) AS on_process
FROM
(
	SELECT
		so.quotation_no AS "no"
		, so.create_date AS "date"
		, pp.name AS "currency"
		, gs.name AS "group"
		, ru.login AS "sales"
		, rp.display_name AS "costumer"
		, so.amount_untaxed AS "total_tax"
		, CASE
			WHEN so.quotation_state NOT IN('win','lost')
			THEN 'on process' ELSE so.quotation_state
			END AS "status"
	FROM
		sale_order so
	LEFT JOIN
		product_pricelist pp ON pp.id = so.pricelist_id
	LEFT JOIN
		res_users ru on ru.id = so.user_id
	LEFT JOIN
		res_partner rp on rp.id = so.partner_id
	LEFT JOIN
		group_sales gs on gs.id = ru.kelompok_id
	--WHERE so.quotation_state = 'lost'
) AS rfq
GROUP BY rfq.group