SELECT sum(decode(trunc(schedule_date),trunc(date_closed),1,0)) number_filled, count(*) number_due, trunc(schedule_date) day, warehouse_id from wsh_bis_fill_rate_v group by trunc(schedule_date), warehouse_id
View Text - HTML Formatted
SELECT SUM(DECODE(TRUNC(SCHEDULE_DATE) , TRUNC(DATE_CLOSED) , 1 , 0)) NUMBER_FILLED , COUNT(*) NUMBER_DUE , TRUNC(SCHEDULE_DATE) DAY , WAREHOUSE_ID FROM WSH_BIS_FILL_RATE_V GROUP BY TRUNC(SCHEDULE_DATE) , WAREHOUSE_ID