Posts by Alan da Matta • 36 points

• 2

  votes

  1

  answer

  96

  views

  A: Get sales average for a given month

  Do not use 'like' for dates, use between or larger and smaller than. Ex.: select avg(a.vend_qtde) from tb_vendas a where a.esto_descricao like '%Saco pedra%' and vend_data between '2018-01-01' and…

  mysql sql postgresql

  answered 6 years, 6 months ago Alan da Matta 36