This query will return all people who made a SINGLE payment of $250 or more during 2004.

select e.salutation,
e.firstname,
e.lastname,
n.displayname,
n.addressline1,
n.addressline2,
n.city,
n.state,
n.zip,
p.paymentdate,
p.paymentdesc,
p.paymentamount
from camnamesv n, campayments p, campeople e
where n.nameid = p.nameid
and n.nameid = e.nameid
and p.paymentamount > 250
and p.paymentdate >= '01-JAN-2004'
and p.paymentdate <= '31-DEC-2004'