title: need query for below output format
body: <p>i have using table name smart_temp.checker.</p>
  
  <p>This table contains below results:</p>
  
  <pre><code>select * from smart_temp.checker 
  </code></pre>
  
  <p><strong>Table</strong></p>
  
  <pre><code>account-number    type_of_approver  status    remarks
  11                     chck1        ok        approved
  11                      chk2        ok        approved
  12                      chck1       reject    mismatch
  12                      chck1       ok        approved
  12                      chck2       ok        approved
  13                      chk1        reject    mismatch
  13                      chk1        reject    mismatch
  13                      chk1        ok        approved
  13                      chk2        reject    address not clear
  13                      chk2        ok        approved
  14                      chk1        reject    mismatch
  14                      chk2        reject    mismatch
  </code></pre>
  
  <p>Now my output is display below this format</p>
  
  <pre><code> no of accounts   : 
   ok without reject :   
   ok after one reject :
   ok after two reject:
   rejected not processed again:
  </code></pre>
  
  <p>Now how to write query for this condition.i have tired wrote query i cannot get any idea how to write about this condition</p>