About Error in my code

Hi, I was trying my best to figure out the error in the below code, the exercise is :
task 6. Please help me!

SELECT users,count(url)

FROM hacker_news

WHERE url like "%https://www.youtube.com/watch?v=dQw4w9WgXcQ%"


What’s the error message? Or, does nothing print?
Step 6 uses CASE....WHEN

Can you please paste all your SQL code?

sorry, I meant task five

Mainly just the typo: It appears the column is user, not users

As an aside: As you’re only trying to collect data about people posting the link, you don’t need to have the full YouTube link; just the las part: %watch?v=dQw4w9WgXcQ%

1 Like