select          a.device_id  device_id,         a.university university,         count(question_id),         sum(case&nb...

select t1.device_id,t1.university, count(question_id) question_cnt, sum(right_question) right_question_cnt from     ( select          a.device_id  device_id,        &nbsp...

select substr(event_time,1,7) as month,sum(total_amount) as GMV from tb_order_overall where status=0 or status=1 and year(event_time)=2021 group by substr(event_time,1,7) having sum(total_amount)>100000 order by sum(total_amount)