select
timestampdiff(SQL_TSI_HOUR, ObsoleteDate, storn) as diff,
case when UnitMeasureCode='platnosci' or UnitMeasureCode like '%PayU - szybkie%' then 'PAYU' else '' end as payu,
case when UnitMeasureCode in ('moneyorder','Przelew bankowy') then 'przelew' else '' end as przelew
from (select ObsoleteDate,UnitMeasureCode, MIN(ModifiedDate) as storn from nw.billofmaterials group by ObsoleteDate,UnitMeasureCode ) w