P.S., in the future if you post your code here in the forums, please use this button to format it so that it’s easier for all to read:Īfter pressing that button, you will see a prompt that looks like this appear in your editor: This course probably needs to be re-worked to be more learner-friendly, but it should get you started. If you are interested in learning more about subqueries, Codecademy has a short course on them here: SELECT SUM(each_score) / (SELECT SUM(score) * 1.0 FROM hacker_news) FROM each_s Instead, what we can do is use a subquery inside of the in the SELECT clause: WITH each_s AS ( Because we only want the value and not a table with the value, we should not use the WITH.AS syntax to retrieve the total. …as this creates a Common Table Expression (or CTE), which is a type of temporary table. Here, we would want to avoid using this phrase: TOTAL AS( SELECT SUM(score) FROM hacker_news) Subqueries are just regular queries that are nested inside a specific clause of your main query. One way to accomplish what you’re trying to do would be to use subqueries. Is there anyway to do this math automatically and got 22% as result INSTEAD OF typing 517 + 309 + 304 + 2? Syntax to get the total is SELECT SUM(score) FROM hacker_news Now I need to take 1412 to divide for Total score (6366) BUT I do not want to manually type 6366 in HAVING each_score > 200), TOTAL AS( SELECT SUM(score) FROM hacker_news) WITH each_s AS ( SELECT user, SUM(score) as each_score I do not want to manually type the numbers for the division so I used these syntax to get Sum So, is Hacker News dominated by these users? Then, we want to add these users’ score s together and divide by the total to get the percentage.Īdd their scores together and divide it by the total sum.
0 kommentar(er)
