Topic: GROUP uzklausa, iterpiant neegzistuojancius rezultatus
SELECT to_char(order_creation_date, 'YYYY-MM-DD') AS diena,
avg(resolut_duration_hours), dep
FROM cache
WHERE order_creation_date::date >= NOW() - INTERVAL '7 DAY'
AND tag = 'T' and duration_hours < '48'
GROUP BY diena, dep
ORDER BY diena asc
OUTPUT:
Array
(
[diena] => 2012-11-24
[avg] => 5.40454251461988
[dep] => pirmas
)
Array
(
[diena] => 2012-11-24
[avg] => 21.1284629761905
[dep] => antras
)
Array
(
[diena] => 2012-11-25
[avg] => 30.4637633730159
[dep] => pirmas
)
2012-11-25 diena buvo aktyvus tik pirmas skyrius (dep), todel antro skyriaus rezultatu nera, taciau man reiktu kad grazintu 0 t.y
Array
(
[diena] => 2012-11-25
[avg] => 0
[dep] => antras
)