Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH cars AS (SELECT 'Tesla' MAKE, to_date('2024-03-15', 'yyyy-mm-dd') issue_date, 2 cnt FROM dual UNION ALL
              SELECT 'Subaru' MAKE, to_date('2024-03-15', 'yyyy-mm-dd') issue_date, 3 cnt FROM dual UNION ALL
              SELECT 'Subaru' MAKE, to_date('2024-03-14', 'yyyy-mm-dd') issue_date, 11 cnt FROM dual UNION ALL
              SELECT 'Tesla' MAKE, to_date('2024-03-13', 'yyyy-mm-dd') issue_date, 10 cnt FROM dual UNION ALL
              SELECT 'Subaru' MAKE, to_date('2024-03-13', 'yyyy-mm-dd') issue_date, 6 cnt FROM dual UNION ALL
              SELECT 'Tesla' MAKE, to_date('2024-03-12', 'yyyy-mm-dd') issue_date, 8 cnt FROM dual UNION ALL
              SELECT 'Subaru' MAKE, to_date('2024-03-12', 'yyyy-mm-dd') issue_date, 12 cnt FROM dual UNION ALL
              SELECT 'Tesla' MAKE, to_date('2024-03-11', 'yyyy-mm-dd') issue_date, 17 cnt FROM dual UNION ALL
              SELECT 'Subaru' MAKE, to_date('2024-03-11', 'yyyy-mm-dd') issue_date, 4 cnt FROM dual UNION ALL
              SELECT 'Tesla' MAKE, to_date('2024-03-10', 'yyyy-mm-dd') issue_date, 6 cnt FROM dual UNION ALL
              SELECT 'Subaru' MAKE, to_date('2024-03-10', 'yyyy-mm-dd') issue_date, 9 cnt FROM dual),
      dts AS (SELECT  trunc(sysdate) - level + 1 issue_date
              FROM    dual
              CONNECT BY LEVEL <= 7)
SELECT cars.make,
       dts.issue_date,
       NVL(cars.cnt, 0) cnt
FROM   dts
       LEFT OUTER JOIN cars PARTITION BY (cars.make) ON dts.issue_date = cars.issue_date
ORDER BY dts.issue_date DESC,
         cars.make DESC;

MAKE	ISSUE_DATE	CNT
Tesla	09-FEB-25	0
Subaru	09-FEB-25	0
Tesla	08-FEB-25	0
Subaru	08-FEB-25	0
Tesla	07-FEB-25	0
Subaru	07-FEB-25	0
Tesla	06-FEB-25	0
Subaru	06-FEB-25	0
Tesla	05-FEB-25	0
Subaru	05-FEB-25	0
Tesla	04-FEB-25	0
Subaru	04-FEB-25	0
Tesla	03-FEB-25	0
Subaru	03-FEB-25	0