SELECT * FROM snow WHERE snow = 'Yes'  and oldstring is not null)
SELECT   
    id, issue_key,  
   CASE   
        WHEN newstring = 'Done' THEN date_diff('second',MIN(created_status) OVER (PARTITION BY issue_key),MAX(created_status) OVER (PARTITION BY issue_key)) 
        ELSE date_diff('second',MIN(current_timestamp) OVER (PARTITION BY issue_key), MIN(created_status) OVER (PARTITION BY issue_key)) END AS time  
FROM filtered_snow