This two query gives the same result .So what’s the difference between two?
/*Next, we need to pinpoint the users who have accumulated a lot of points across their stories.
Find the individual users who have gotten combined scores of more than 200, and their combined scores.*/
SELECT user , SUM(score) AS ‘Total Score’ FROM hacker_news
GROUP BY user HAVING SUM(score) >200 ORDER BY 2 DESC;
SELECT user, score FROM hacker_news WHERE score> 200 ORDER BY 2 DESC;