documentation/Reference Code/Wedge/installation/mysql/is4c_op/views/volunteerDiscounts.viw
use is4c_op;
DROP VIEW IF EXISTS `volunteerDiscounts`;
CREATE VIEW `volunteerDiscounts` AS
select
`CardNo` AS `CardNo`,
`SSI` AS `hours`,
(`SSI` * 20) AS `total`,
`id` AS `id`
from `custdata` where `staff` = 3