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