Help with query

Folks,

How would I modify this to add values for each day rather than giving me a breakdown?

select * from (

select 'metric_chute_jam_t_dest' Metric, year, month, day, device, dest, sum(value) from metric_chute_jam_t_dest where (length(device)>0 and device!='0' ) group by year, month, day, device, dest

) t where device = 0005