List all the inactive coins and state the last date of its transaction?
the last date refers to max(date); inactive coins refers to status = 'inactive'
SELECT T1.NAME, MAX(T2.DATE) FROM coins AS T1 INNER JOIN historical AS T2 ON T1.ID = T2.coin_id WHERE T1.status = 'inactive' ORDER BY T2.DATE DESC LIMIT 1