select 'main_total', A.total FROM ( select s.review_by, count(s.question_id) as total from pencil_content.qst_master_main s where s.review_by <> '') as A UNION ALL select s.review_by, count(s.question_id) as total from pencil_content.qst_master_main s where s.review_by <> '' group by s.review_by order by total DESC;
No comments:
Post a Comment