rem :Report to get information about time entry

ttitle 'Employee Time Information'
btitle 'from videmp table'

column eid heading 'identity'

column wage heading 'wage'

column hrs_wrk heading 'hours'

column wage*hrs_wrk heading 'Pay'

break on wage skip 2
compute sum of wage
break on hrs_wrk skip 2
compute sum of hrs_wrk
break on wage*hrs_wrk skip 2
compute sum of wage*hrs_wrk

set linesize 75
set pagesize 25
set newpage 2

spool activity.1st


select eid, wage, hrs_wrk, wage*hrs_wrk as Payment from videmp order by eid;

select sum(wage) as wagetot, sum(hrs_wrk) as hrstot, sum(wage*hrs_wrk) as totpay from videmp;

spool off
