Hi all, I have the following db: Status client (from a to n) -character Market (multiples) -character id_client (multiple codes) -character observation date (date from 1 to 3) -date amount - numeric I need to create a DB where I can follow each client over time, i.e. a DB with the following variables market, Id client, sum(amount at date1), sum(amount) at date2, sum(amount) at date 3, status of client at date1, status of client at date2, staus of client at date3. Could you suggest me a code that could work? Thank you very much AA
... View more