Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select Fu.idFuncionario, Fu.nome sum(A.preco * V.quantidade) as valor_vendas
- from VendasArtigos V join
- Artigo A
- on V.idArtigo = A.idArtigo
- join Fatura F
- on F.idFatura = V.idFatura
- join Funcionario Fu
- on fu.idFuncionario = f.idFuncionario
- where F.dataHora <= getdate() and F.dataHora > dateAdd("m", -1, getdate())
- group by Fu.idFuncionario
- order by valor_vendas DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement