select Question_desc,
sum(if(ifnull(question_value,"")="Y",1,0)) "نعم",
sum(if(ifnull(question_value,"")="N",1,0)) "لا",
sum(if(ifnull(question_value,"")="L",1,0)) "قليلا",
sum(if(ifnull(question_value,"")="F",1,0)) "وسط"
from Qprofdt inner join question on question.question_Id = Qprofdt.question_Id
group by Question_desc order by "نعم"