title: Mysql Error Code: 1111. Invalid use of group function
body: <p>Can't figure out how a query such as the following one can throw such error in MySql.</p>
  
  <pre><code>INSERT INTO
  
  tbl1.monthlydata(Led,
  Lev2,
  Date,
  Dimension,
  Dimension1,Currency,
  CurrAmount,
  Amount)
  
  
  values('999999','AA9999','2020-01-01','6666','AAAAAAA','STR',10,10)
  </code></pre>
  
  <p>there is no aggregating function and if I try to enter manually the same values in the table it works</p>