SELECT MAX(GP.ISSUE_DATE),GE.INSURANCE_AMOUNT 
FROM GI_EMPLOYEE_POLICIES GE , GI_POLICIES GP
WHERE GE.POLICY_ID = GP.GI_POLICY_ID
AND GE.EMP_ID =6
GROUP BY GE.INSURANCE_AMOUNT 

14:57:57 SQL> SELECT MAX(GP.ISSUE_DATE),GE.INSURANCE_AMOUNT
15:02:22   2  FROM GI_EMPLOYEE_POLICIES GE , GI_POLICIES GP
15:02:22   3  WHERE GE.POLICY_ID = GP.GI_POLICY_ID
15:02:22   4  AND GE.EMP_ID =6
15:02:22   5  GROUP BY GE.INSURANCE_AMOUNT
15:02:23   6  /
FROM GI_EMPLOYEE_POLICIES GE , GI_POLICIES GP
                               *
ERROR at line 2:
ORA-00942: table or view does not exist

SQL> select  max(hiredate),
  2          sal
  3    from  emp
  4    group by sal
  5    order by max(hiredate)
  6  /

MAX(HIRED        SAL
--------- ----------
17-DEC-80        800
20-FEB-81       1600
02-APR-81       2975
01-MAY-81       2850
09-JUN-81       2450
08-SEP-81       1500
28-SEP-81       1250
17-NOV-81       5000
03-DEC-81        950
23-JAN-82       1300
19-APR-87       3000

MAX(HIRED        SAL
--------- ----------
23-MAY-87       1100

12 rows selected.

SQL> select  max(max(hiredate)),
  2          max(sal) keep(dense_rank last order by max(hiredate))
  3    from  emp
  4    group by sal
  5  /

MAX(MAX(H MAX(SAL)KEEP(DENSE_RANKLASTORDERBYMAX(HIREDATE))
--------- ------------------------------------------------
23-MAY-87                                             1100

SQL> 

select  GE.INSURANCE_AMOUNT
from  GI_EMPLOYEE_POLICIES GE 
where GE.EMP_ID =6
AND  GE.POLICY_ID  IN (SELECT  GP.GI_POLICY_ID FROM GI_POLICIES GP
WHERE GP.ISSUE_DATE =(SELECT MAX(ISSUE_DATE) FROM GI_POLICIES GP , GI_EMPLOYEE_POLICIES GE
WHERE GE.POLICY_ID = GP.GI_POLICY_ID
AND  GE.EMP_ID =6
  )
  AND GP.POLICY_NO = 1)