zOs/SQL/OCF2
select
o1.tid150uui, o1.cnt,
o2.tid150tst, o2.tid150cha,
o3.tid150tst, o3.tid150cha
from
(select
tid150uui, count(*) cnt,
min(tid150tst) minTst, max(tid150tst) maxTst
from oa1a . tid150a1
group by tid150uui
having count(*) > 0
) o1
join
(select
tid150cha, tid150tst, tid150uui
from oa1a . tid150a1
) o2
on o2.tid150tst = o1.minTst
and o2.tid150uui = o1.tid150uui
left join
(select
tid150cha, tid150tst, tid150uui
from oa1a . tid150a1
) o3
on o3.tid150tst = o1.maxTst
and o3.tid150uui = o1.tid150uui
and o3.tid150tst > o2.tid150tst
order by o1.tid150uui asc
;