As an experiment, I will be listing the SQL used to generate reports in ToyBase.

select memnum, name, Joined, max(History.borrowed) as 'LastBorrowed'
from Members
join History on Members.memnum = History.memnum
where History.borrowed >= CURRENT_DATE-365
and Members.DateLeft > 10000
group by memnum, name, Joined