title: Optimise Mysql Query
body: <p>I would like to optimise the query I have below:</p>
  <pre><code>SELECT
                        a.id, a.pay_point_name, a.pay_point_location,
                        COUNT(b.id) AS countedCustomers,
                        SUM(b.approved) AS summedLoans,
                        SUM(c.deduction) AS summedDeductions 
                    FROM
                        pay_tbl a 
                    LEFT JOIN
                        customer_tbl b 
                            ON b.employer = a.pay_point_name 
                    LEFT JOIN
                        loans_tbl c 
                            ON c.paypoint = a.pay_point_name 
                    GROUP BY
                        a.pay_point_name 
                    ORDER BY
                        NULL
  </code></pre>
  <p>Current Execution time: 161.2s</p>
  <p>EXPLAIN statement gives me the table below:
  <a href="https://i.stack.imgur.com/U9ydN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/U9ydN.png" alt="EXPLAIN statement gives me this table" /></a></p>
  <p>I would like to know how best to optimise this query and reduce execution time.</p>