select 
	tsa1.ticket_ID, ts1.name, tsa1.date_updated as date_opened,
	(select min(date_updated) from TICKET_STATE_AUDIT where date_updated >= tsa1.date_updated and ticket_ID = tsa1.ticket_ID and state_ID = (select ID from TICKET_STATE where name = 'closed'))
from
	TICKET_STATE_AUDIT as tsa1
		left join TICKET_STATE as ts1 on tsa1.state_ID = ts1.ID
where
	tsa1.ticket_ID = 4
and
	tsa1.state_ID = (select ID from TICKET_STATE where name = 'open')