SELECT
	pa.No_Proposal,
	prs.Nama_Perusahaan
FROM
	dbo.Polis_Asuransi AS pa INNER JOIN
	dbo.Perusahaan AS prs ON pa.No_Prs = prs.No_Prs INNER JOIN
	dbo.Produk_Polis AS pp ON pa.No_Proposal = pp.No_Proposal
WHERE
  prs.GT_OG = 'GT'
  AND pa.Status = 'I'
  AND pp.Status = 'I'
  AND pp.Sub_Kelompok = '0301'
GROUP BY
  pa.No_Proposal,
	prs.Nama_Perusahaan
HAVING
  COUNT(*) > 1
ORDER BY
  prs.Nama_Perusahaan

SELECT
	pa.No_Proposal,
	prs.Nama_Perusahaan
FROM
	dbo.Polis_Asuransi AS pa INNER JOIN
	dbo.Perusahaan AS prs ON pa.No_Prs = prs.No_Prs INNER JOIN
	dbo.Produk_Polis AS pp ON pa.No_Proposal = pp.No_Proposal
WHERE
  prs.GT_OG = 'GT'
  AND pa.Status = 'I'
  AND pp.Status = 'I'
  AND pp.Sub_Kelompok = '0302'
GROUP BY
  pa.No_Proposal,
	prs.Nama_Perusahaan
HAVING
  COUNT(*) > 1
ORDER BY
  prs.Nama_Perusahaan