use testdb;

select method from qa_log
where method is not null and method!='N/A'
group by method;