title: MySQL unknown column in my query
body: <p>I have the following MySQL query</p>
  <pre><code>select 
      keliones_lapas.Vairuot_Id, 
      MONTH(keliones_lapas.Data_darbo), 
      sum(keliones_lapas.uzdarbis) as Got, 
      coalesce(Suma, 0) Suma, 
      (sum(keliones_lapas.uzdarbis) - coalesce(Suma, 0)) Total
  from keliones_lapas
  left join (select Vairuotas, MONTH(Data_islaidu), sum(Suma) as Spend from 
      islaidos group by Vairuotas, MONTH(Data_islaidu))
      islaidos on 
      keliones_lapas.Vairuot_Id=islaidos.Vairuotas and 
      MONTH(keliones_lapas.Data_darbo)=MONTH(islaidos.Data_islaidu)
  group by keliones_lapas.Vairuot_Id, MONTH(keliones_lapas.Data_darbo), Suma
  order by keliones_lapas.Vairuot_Id, MONTH(keliones_lapas.Data_darbo);
  </code></pre>
  <p>And i'm getting this error:</p>
  <h1>1054 - Unknown column 'Suma' in 'field list'</h1>
  <p>I know that this issue is known but i do not know how to fix it by my self.
  <a href="https://stackoverflow.com/questions/4065985">This is the cause of the issue which is solved</a></p>
  <p>And i can provide with the fiddle : <a href="http://sqlfiddle.com/#!9/e76ef9/8" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/e76ef9/8</a></p>