SELECT CASE col1 WHEN 'agree' THEN 'Ok' ELSE CASE WHEN col2 >= 1 THEN 'Ko' ELSE 'Maybe' END END AS my_result FROM table_name;