统计学生成绩。 设有十个学生的成分别是：（自己设定）。统计一下60~69分，70~79分，80~89分，90~99分和100分的人数并存放在s6,s7,s8,s9,s10单元中。（通过对子程序的调用实现）-student achievement statistics. With 10% of the students were : (self-imposed). Statistics about 60 to 69 points, 70 to 79 points, 80 to 89, 90 to 99 points and 100 points on both the number of M16, s670, S8, s9, s 10 modules. (Through subroutine calls realization)
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001669s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.125425s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000920s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001134s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001028s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003161s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000895s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003838s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015446s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001138s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 303776 [ RunTime:0.026248s ]
