题解 | #统计作答次数#
统计作答次数
http://www.nowcoder.com/practice/45a87639110841b6950ef6a12d20175f
SELECT
COUNT(*) AS total_pv,
COUNT(submit_time) AS complete_pv,
COUNT(DISTINCT exam_id AND score is not NULL) AS complete_exam_cnt
FROM exam_record
统计作答次数
http://www.nowcoder.com/practice/45a87639110841b6950ef6a12d20175f
SELECT
COUNT(*) AS total_pv,
COUNT(submit_time) AS complete_pv,
COUNT(DISTINCT exam_id AND score is not NULL) AS complete_exam_cnt
FROM exam_record
相关推荐
专业嗎喽:个人信息名字太大,合到电话邮箱那一栏就行,有党员写过党,剩下其他全删,站空太大了
把实习经历丰富,放最前面,然后是个人评价,技能之类的,然后是学校信息。项目经历最后面,可以就选一个自己擅长的。
现在是学校不是92就扣分的,没必要放前面。
然后现在看重实习经历>竞赛经历(校园经历)>课程项目经历