Hi, I have a data set as described below: donor id donation amt donation date payment type appeal id 001234 £20 26/11/2005 direct debit HHU 001234 £15 28/12/2006 cash HHI 001236 £10 16/8/2007 direct debit HHJ 1.First, i want to merge data from another table (which has same donor id but with their age, city and gender) to the above 2.Then Create a table that has the total amount donated by each donor id; the first date of donation; last date of donation; the number of times they have donated(how many times they have donated from the first date of donation) exclude, payment type and appeal id from the output. Thanks.
... View more