Is there a better way to write this?

Basically, I wanted to achieve a similar result as seen in the screenshot but with the LIKE operator. However, when I use the % wildcard the table only includes the first string query. I managed to get the result anyway with the IN operator but I would like to understand how to get the same result with the LIKE operator if it is indeed possible.

    %%sql
SELECT Mission_Outcome, count(Mission_Outcome) as Count
FROM SPACEXTBL
WHERE Mission_Outcome LIKE '%Success%' or  '