Test3 status query

SELECT 
    IIF (LOWER(common_name) LIKE '%frog%', 'frog', 'notfrog') AS STATUS,
    scientific_name AS RESULT
FROM species
LIMIT 1;

<div style="background-color: #F8CECC">In debt: :result</div>

<div style="background-color: #D5E8D4">All okay: :result</div>