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
when url like ‘%github%’ then ‘GitHub’
when url like '%medium% then ‘Medium’
when url like ‘%newyorktimes%’ then ‘New York Times’
End as ‘source’
Then it returns result of “other” only. What am I doing wrong here?