Hi

I'm new to this but I have had some success with the following:

SELECT COUNT( t1.Q1 ) AS Q1,

( SELECT COUNT( t2.Q2 ) FROM tablename t2 WHERE t2.Q2 = 'Yes' )...