sql

I am trying to use Hive QL to retrieve data from the database. I have 2 columns start_time having the starting time and time_stamp which is recorded for each of the works done starting from ‘Start_time’ JOB start_time work_done time_stamp ————————————————————————- JOB_A 2021/12/29 11:00:00 work_A 2021/12/29 11:00:00 JOB_A 2021/12/29 11:00:00 work_A 2021/12/29 11:20:00 JOB_A 2021/12/29…