Joining input table and table with the missing values in our dataset

ListedArticlesPerShop_with_Filled_missing_date_ranges.sql

SELECT 
  table_a.ascending_date,
  table_a.shop,
  CASE WHEN 
    table_b.new_article_count IS null 
  THEN 0 
  ELSE 
    table_b.new_article_count 
  END AS number_of_listed_articles 
FROM 
(
  SELECT
    CAST(day AS DATE) as ascending_date,
    sb.shop as shop
  FROM
    (SELECT '3djake' as shop
      UNION ALL SELECT 'geero') sb,
    (SELECT
        day
      FROM
        UNNEST(
          GENERATE_DATE_ARRAY(
            DATE('2021-01-01'),
            CURRENT_DATE(),
            INTERVAL 1 DAY
          )
        ) AS day
      ) 
  ) table_a
  LEFT JOIN
  (SELECT '3djake' as shop, 20 as new_article_count, DATE(2021, 01, 05) as article_online_since_date
      UNION ALL SELECT '3djake', 10, DATE(2021, 01, 07)
      UNION ALL SELECT '3djake', 5, DATE(2021, 01, 10)
      UNION ALL SELECT '3djake', 8, DATE(2021, 01, 10)
      UNION ALL SELECT '3djake', 5, DATE(2021, 01, 21)
      UNION ALL SELECT '3djake', 15, DATE(2021, 01, 23)
      UNION ALL SELECT 'geero', 12, DATE(2021, 01, 01)
      UNION ALL SELECT 'geero', 2, DATE(2021, 01, 04)
      UNION ALL SELECT 'geero', 5, DATE(2021, 01, 08)
      UNION ALL SELECT 'geero', 1, DATE(2021, 01, 23)
      UNION ALL SELECT 'geero', 4, DATE(2021, 01, 30)
    ) table_b
  ON 
    table_a.shop = table_b.shop
  AND 
    table_a.ascending_date = table_b.article_online_since_date