sql teste postgres

select sum(valor),extract(year from data) as ano,extract(MONTH from data) as mes from venda GROUP BY extract(year from data),extract(MONTH from data) having extract(year from data)=2019 and extract(MONTH from data)=5