Help! Hacker news project

https://www.codecademy.com/paths/data-science/tracks/sql-intermediate/modules/dspath-sql-aggregates-projects-and-applications/projects/sql-hackernews

I’m in the middle of hacker news project and I’m stuck at step 6 where I have to use CASE statement. I looked at the hint and followed exactly what it says but it still gives me results with one column saying “other”

Here’s is what I have so far

Select CASE
when url like ‘%github%’ then ‘GitHub’
when url like '%medium% then ‘Medium’
when url like ‘%newyorktimes%’ then ‘New York Times’
Else ‘Other’
End as ‘source’
from hacker_news;

Then it returns result of “other” only. What am I doing wrong here?
Help please!

I’m having the same problem with this one, did you ever figure it out?

Yes! I finally figured out. Are you still stuck?