Hiii I want to use select in select clause
this is my statement which got an error:
Select count(*) as cnt, (select count (answer_q1) from answers where (answer_q1 = 'ضعيف'))as a_q1 FROM Answers
and this is the error:
Error in SELECT clause: expression near 'SELECT'.
Error in SELECT clause: expression near 'FROM'.
Missing FROM clause.
Unable to parse query text.
DO YOU ANY OTHER WAY TO WRITE THE STATEMENT AND GET SAME RESULT?????? hELP ME PLEASE