create table gtest1(Tdate date, asset_name varchar2(100),asset_value number);
insert into gtest1 values('01-AUG-2025','ABC',100);
insert into gtest1 values('01-AUG-2025','ABC',300);
insert into gtest1 values('01-AUG-2025','ABC',400);
insert into gtest1 values('01-AUG-2025','ABC',600);
insert into gtest1 values('02-AUG-2025','ABC',100);
insert into gtest1 values('02-AUG-2025','ABC',300);
insert into gtest1 values('02-AUG-2025','ABC',400);
insert into gtest1 values('02-AUG-2025','ABC',600);
insert into gtest1 values('04-AUG-2025','ABC',100);
insert into gtest1 values('04-AUG-2025','ABC',300);
insert into gtest1 values('04-AUG-2025','ABC',400);
insert into gtest1 values('04-AUG-2025','ABC',600);
insert into gtest1 values('05-AUG-2025','ABC',100);
insert into gtest1 values('05-AUG-2025','ABC',300);
insert into gtest1 values('05-AUG-2025','ABC',400);
insert into gtest1 values('05-AUG-2025','ABC',600);
COMMIT;
SELECT COUNT(*),ASSET_NAME,TDATE
FROM GTEST1
GROUP BY ASSET_NAME,TDATE
ORDER BY TDATE;
Data is missing for august 3rd, so given a range of august 1 - till august 31 - how can I print the days where there is no data at all?