Estelio Gomes Mataragia

Moderators
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

2 Neutral

About Estelio Gomes Mataragia

  • Rank
    Soldier
  1. SELECT v.datmov, COALESCE(SUM((CASE WHEN v.Cancelado = 'S' THEN tot_ven ELSE 0 END)),0) AS CANCELADO, COALESCE(SUM((CASE WHEN v.Cancelado= 'N' THEN tot_ven ELSE 0 END)),0) AS NORMAL FROM VENDAS v WHERE v.datmov between '01/01/2020' and '01/31/2020' GROUP BY v. datmov