Nested if in mysql

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

Similar codes

0 vote216 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote300 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
5 votes213 views1 answer
Oracle add time to date
SQL
1 vote195 views1 answer
Float precision in psql
SQL
0 vote193 views1 answer
Power bi dax add related shows column but not working
SQL
40 votes230 views4 answers
PostgreSQL add column
SQL
-1 vote193 views1 answer
How to switch user in mysql
SQL
0 vote194 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote201 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote198 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL