mingzzc

分类

题解(1)

/ 注册

全部文章（共1篇）

题解 | #统计复旦用户8月练题情况#

select t1.device_id,university,count(question_id) as 'question_cnt',sum(if(t2.result='right',1,0)) as 'right_question_cnt' from user_profile as t1 lef...

Mysql

2022-04-15

0 361