use testdb;

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