Что будет результатом запроса
select
lp.customer_id
,lp.last_name
,lp.first_name
,lp.middle_name
,max(lp.application_type) KEEP (DENSE_RANK LAST ORDER BY (lp.date_ins)) as application_type
,max(lp.credit_amount) as credit_amount

from
LP_table lp
group by
lp.customer_id
,lp.last_name
,lp.first_name
,lp.middle_name