select part , tst 00010000
from a540769.twk925switch 00011001
where tst = (select max(tst) 00020000
from a540769.twk925switch 00020100
where tst < current timestamp - 55 day 00020204
) 00020300
; 00020405
select * from a540769.vwk925current 00020506
; 00020607
select * from a540769.vwk925 00020707
fetch first 100 rows only 00020807