hi all i need to create a chart report from sql querys but i dont have a clue in how to do it!

ex. i have a sql table were i neet to:
Code:
SELECT COUNT FROM LOAD.Q1 WERE Q1 = "YES"
and 10 more querys just like this one!
now i need to populate the report chart with tose querys