could sql create view with fix group even without data
create table t1(day varchar2(20),qty number);






create table t2(day varchar2(20));






insert into t1 values('Sunday',10)






insert into t1 values('Monday', 5);






insert into t1 values('Tuesday', 20)






insert into t1 values('Sunday',17)






insert into t2 select trim(to_char(sysdate+level,'Day')) WeekDay from dual connect by level&lt;=7;






select t2.day, nvl(sum(t1.qty),0) Sum_qty from t1 right outer join t2 on(t1.day=t2.day) group by t2.day;



DAY       | SUM_QTY
:-------- | ------:
Tuesday   |      20
Sunday    |      27
Monday    |       5
Wednesday |       0
Thursday  |       0
Saturday  |       0
Friday    |       0



OR

create view sum_table as
select t2.day, 
       nvl(sum(t1.qty),0) Sum_qty 
from t1 
right outer join 
       (select trim(to_char(sysdate+level,'Day')) Day 
                from dual 
                connect by level&lt;=7)t2 
on(t1.day=t2.day) 
group by t2.day;


dbfiddle here