title: Joining tables with count and sum
body: <p>I have two tables 
  loanform and schedule_loanform
  loanform
  <a href="https://i.stack.imgur.com/4Uszh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4Uszh.png" alt="enter image description here"></a></p>
  
  <p>I need the MySQL query but could not solve it can anyone help me?</p>