help me to construct the query

[Anees Anees]

Hi,

I have 3 tables

Questions
--------------
Q_id
Qustion

Common_answers
----------------------------
common_id
user_id

All_answers
------------------
id
Q _id
Answer(Y/N)
common_id


Its a survey type of questions. Users can answers how many times they want (either Yes or No for each question).
Each time they answers, one record will be stored into 'Common_answers'
And all question's answers will be stored into 'All_answers' with one 'common_id'

i need to get a report to list how many times he answered with answer 'Y', total number of attempts and the percentage of Yes.
for eg:
Question 1 50%(3 of 6)
Question 2 100%(6 of 6)
Question 3 0%(0 of 6)
Question 4 66.67%(4 of 6)


Is it possible to get all these data from database using one query
I have tried to get the desired output but couldn't succeed yet
Please help in queries to get these results

Regards
Anees