Which sites feed Hacker News?

[oldoc63]

Hacker News stories are essentially links that take users to other websites. Which of these sites feed Hacker News the most: Github, Medium or New York Times? First, we want to categorize each story based on their source. We can do this using a CASE statement:

[oldoc63]

Next, build on a previous query:

• Add a column for the number of stories from each URL using COUNT().
• Also, GROUP BY the CASE statement.
• Remember that you can refer to a column in GROUP BY using a number.