Hi I have the following table:
| NAme | Date | Amount |
|---|
| a | 05/05/1999 | 2 |
| a | 18/05/1999 | 3 |
| a | 27/05/1999 | 4 |
| b | 24/05/2001 | 5 |
| b | 26/05/2001 | 7 |
| b | 28/05/2001 | 9 |
For each distinct Name I need a list of the lowest date in the month and a list of the max date in the month.
I need to convert it to the following:
| NAme | min date | min amount | max date | max amount |
|---|
| a | 05/05/1999 | 2 | 27/05/1999 | 4 |
| b | 24/05/2001 | 5 | 28/05/2001 | 9 |
| | | | |
What is the easiest way to do this?
Thanks
