Stored Procedure for calculating total no of leave

Question

Need to write stored procedure & need to create a event scheduler in mysql for total leaves for an employee & balance leaves..