I need help to write a PL SQL script that will show the Date on which a Sales Rep completed a target of $1million sales for a customer account.
However, for some reason,after touching $1 million, if the sales goes down below $ 1 million and then climbs back again then that Date should not be picked.
Table structure can be:
Rep_Code Date Revenue Office_Code
Can someone please suggest.