PL SQl script to get Date when $1million revenue is reached

[Paresh Jagnade]

Just modifying the query mentioned above, instead of MAX apply MIN to get the first time the person has reached 1$Million amount

select rep_code, min(rep_date),revenue
from sales
where revenue='1.0M'
group by rep_code,revenue