title: I'm new to SQL and thinking is there any way to simplify this Query?
body: <p>Im really new to SQL, doing this for my basic needs for works and basically I'm not a tech guy. But I'm curious to know is there any way to simplify my SQL Code here:</p>
  
  <pre><code>SET sql_mode = '';
  
  
  SELECT DISTINCT partner.kode_agent,
                  institusi.nama,
                  count(proposal.kode_proposal) AS 'Jumlah Proposal',
                  sum(project.jumlah_pencairan) AS 'Jumlah Pencairan'
  FROM brw_proposals proposal
  JOIN ms_agent partner ON proposal.kode_agent = partner.kode_agent
  JOIN ms_agent_institusi institusi ON partner.kode_institusi = institusi.kode_institusi
  JOIN ms_projects project ON proposal.kode_proposal = project.kode_proposal
  WHERE institusi.nama like 'BMT%' and proposal.status_proposal_id = 4
    OR institusi.nama like 'BMT%' and proposal.status_proposal_id = 8
    OR institusi.nama like 'BMT%' and proposal.status_proposal_id = 3
    OR institusi.nama like 'BMT%' and proposal.status_proposal_id = 10
    OR institusi.nama like 'Baitul Maal Wat%' and proposal.status_proposal_id = 4
    OR institusi.nama like 'Baitul Maal Wat%' and proposal.status_proposal_id = 8
    OR institusi.nama like 'Baitul Maal Wat%' and proposal.status_proposal_id = 3
    OR institusi.nama like 'Baitul Maal Wat%' and proposal.status_proposal_id = 10
    OR institusi.nama like 'Ksp%' and proposal.status_proposal_id = 4
    OR institusi.nama like 'Ksp%' and proposal.status_proposal_id = 8
    OR institusi.nama like 'Ksp%' and proposal.status_proposal_id = 3
    OR institusi.nama like 'Ksp%' and proposal.status_proposal_id = 10
  GROUP BY institusi.nama
  </code></pre>
  
  <p>Cause I guess it's too much with the WHERE clause and I'm not so familiar with subquery.</p>
  
  <p>Hope anyone can share their experience to improve my code! Thanks </p>