求一个Mysql存储过程语句

本人在做一个网站系统的时候要用到存储过程，由于mssql和mysql的存储过程语句差别别较大，在网上查了很久也没有查出过所以然，所以求一个mysql的存储过程语句。要求如下：
我创建了一个数据库的视图，创建一个存储过程要用到视图中的查询字段。

视图代码如下：
-- ----------------------------
-- View structure for `teacher_article_view`
-- ----------------------------
DROP VIEW IF EXISTS `teacher_article_view`;
CREATE VIEW `teacher_article_view`
AS
select
`teachersinfo`.`cteachNo` AS `cteachNo`,
`teachersinfo`.`ctrueName` AS `ctrueName`,
`teachersinfo`.`csexual` AS `csexual`,
`schooltables`.`vschName` AS `vschName`,
`articleinfo`.`cartNo` AS `cartNo`,`articleinfo`.
`vartName` AS `vartName`,
`articleinfo`.`vartType` AS `varttype`,
`articleInfo`.`dpubtime` as `dpubtime`,
(`rateresult`.`iResultScore` / `articlepartner`.`irank`) AS `artiScore`
from
((((`articlepartner` join `rateresult`) join `articleinfo`) join `teachersinfo`) join `schooltables`)
where
((`articleinfo`.`cartNo` = `articlepartner`.`cartNo`) and (`teachersinfo`.`cteachNo` = `articlepartner`.`cteachNo`)
and (`articlepartner`.`cResultNo` = `rateresult`.`cResultNo`) and (`teachersinfo`.`cschNo` = `schooltables`.`cschNo`));

我想统计得出上面视图中 'artiScore' 的总和，条件是根据 'cteachNo' 来统计和 'dpubtime' 的一个时间段以内。