select h.TOTAL_NAV
from historique h, AM_NAV_STATUS_TRANSITIONS am
where h.sicovam = am.code
and h.sicovam = 68000339
and h.TOTAL_NAV is not null
and h.jour <= 39623 + to_date('01/01/1904', 'DD/MM/YYYY')
and am.new_state not in (7, 8)
order by h.jour desc;