title: SnowFlake Query if an Id exists on each of the last 7 days
body: <p>We INSERT new records every day to a table with say id and created_on column. </p>
  
  <p>How do i identify if records with a particular identifier existed every day in the last 7 days ?</p>