rem :  Report to get information about Fines

ttitle 'Fines Due'
btitle 'from rents table'

column lname as 'Name'

column phone as 'phone'

column memid as 'ID' 

column fine as 'fine' 



set linesize 75
set pagesize 25
set newpage 2

spool activity.1st


select lname, phone, fine, memid from vidmember, rents where vidmember.memid=rents.cid order by memid;

select sum(fine) as Total_Fines from rents;
spool off
