Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- DATENAME(weekday, factu.fecha) as day,
- COUNT(*) AS operations,
- SUM(factu.total) AS money,
- DATEPART(day, factu.fecha) as date
- FROM factu
- WHERE factu.fecha >= DATEADD(day, -7, GETDATE())
- AND factu.fecha <= GETDATE()
- AND (factu.DEPSTATUS = 'paquete-armado' OR factu.DEPSTATUS = 'entregado')
- GROUP BY DATENAME(weekday, factu.fecha), DATEPART(day, factu.fecha)
- ORDER BY date ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement