Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- COUNT(V.ECF_NUMERO),
- SUM(V.ECF_TOTAL)
- FROM
- VENDAS V
- INNER JOIN CLIENTES C ON (V.CLI_CODIGO = C.CLI_CODIGO)
- WHERE
- V.CLI_CODIGO = '11522'
- AND EXTRACT(YEAR FROM V.ECF_DATA) = 2019
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement