select brand,
       id,
       date,
       datediff(day, (select max(T2.date)
                        from test as T2
                       where T1.brand = T2.brand
                             and T2.date < T1.date) ,date)
  from test as T1
 order by brand, id