How to get the earliest _time of each column hit 100%

[jienlim2]

Hi ,
i have produced output below using predict command .

_time Prediction(hostA) Prediction(HostB) Prediction(HostC)
2019-09-18 90 85 70
2019-09-19 95 88 80

2019-09-20 107 95 90
2019-09-21 120 100 93
2019-09-22 121 105 96
2019-09-23 124 106 99
2019-09-24 130 110 100
2019-09-25 131 120 105

But my question is how can i find the earliest _time for each column where that prediction column is 100 or grater that 100.

Expected output :
Host "Hit 100% next 5 Days" 'Earlist date for host hit 100%'
hostA Y 2019-09-20
HostB Y 2019-09-21
HostC N 2019-09-24