title: Column count doesn't match value count at row 1 by Grouping
body: <p>Can anybody help me with this script what am i doing wrong.....</p>
  
  <pre><code>    insert ignore into `sales`.`salesm`
  
      SELECT
      `sales_imp`.`mktcd`,
      sum(`sales_imp`.`sales_qty_dtl`),
      '0',
      sum(`sales_imp`.`sales_value_dtl`),
      '0',
      `sales_imp`.`yyyymm`,
      `nk_mktcd_itemcd_container_id`,
      `nk_mktcd_itemcd`,
      concat(`nk_mktcd_itemcd`,`sales_imp`.`yyyymm`),
      `agentcd`,
      `nk_mktcd_agentcd`,
      concat(`sales_imp`.`mktcd`,`sales_imp`.`agentcd`,`sales_imp`.`buyer_id_dtl`),
      concat(`sales_imp`.`mktcd`,`sales_imp`.`agentcd`,`sales_imp`.`producer_id_dtl`),
      concat(`sales_imp`.`mktcd`,`sales_imp`.`agentcd`,`sales_imp`.`salesman_id_dtl`),
      `nk_clssiz`
  
  FROM `sales`.`sales_imp`
  group by
  
  `sales_imp`.`mktcd`,
  `sales_imp`.`classid`,
  `sales_imp`.`sizeid`,
  `sales_imp`.`yyyymm`,
  `nk_mktcd_itemcd_container_id`,
  `nk_mktcd_itemcd`,
  `buyer_id_dtl`,
  `sales_imp`.`producer_id_dtl`,
  `sales_imp`.`salesman_id_dtl`,
  `agentcd`,
  `nk_mktcd_agentcd`,
  `nk_mktcd_agentcd_buyer_id`,
  `nk_mktcd_agentcd_producer_id`,
  `nk_mktcd_agentcd_sman_id`,
  `nk_clssiz`;
  </code></pre>