COALESCE and Historical View