SQL & PL/SQL

I am trying to write a case statement which says when STAT is E select the MIN(TERM)
If there is multiple TERM which are both low just pick any. Want one per row per ID.
Is that possible by using case?

Thanks.

CREATE TABLE DAN_GR2
(ID    VARCHAR2(12),
TERM    VARCHAR2(12),
STAT VARCHAR2(12)) 

INSERT INTO DAN_GR2 (ID, TERM,STAT) VALUES ('1','5','E')
INSERT INTO DAN_GR2 (ID, TERM,STAT) VALUES ('1','2','D')
INSERT INTO DAN_GR2 (ID, TERM,STAT) VALUES ('1','9','E')
INSERT INTO DAN_GR2 (ID, TERM,STAT) VALUES ('1','5','E')
INSERT INTO DAN_GR2 (ID, TERM,STAT) VALUES ('2','1','E')
INSERT INTO DAN_GR2 (ID, TERM,STAT) VALUES ('2','10','E')
INSERT INTO DAN_GR2 (ID, TERM,STAT) VALUES ('3,'10','D')

ID 	TERM	STAT
1	5	E
1	2	D
1	9	E
1	5	E
2	1	E
2	10	E
3       10      D

Want

ID   MIN_TERM   
1	5	
2	1
3	NULL

Using:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

Edited by: Chloe_19 on 12/09/2012 18:07