摘要:
1 SELECT c.*, sum(t.num) as num, b.num as total FROM np_wenjuan_choice as c 2 left join ( 3 select content, count(id) as num 4 from np_wenjuan_answer as a 5 where question_id = 8 6 group by content 7 ) as t on t.content like concat('%',c.index,'%') 8 left join ( 9 select question_id, 阅读全文