Comments on: SQL for Data Analysis – Tutorial for Beginners – ep5 https://data36.com/sql-join-data-analysis-tutorial-ep5/ Learn Data Science the Hard Way! Wed, 14 Feb 2024 19:02:10 +0000 hourly 1 https://wordpress.org/?v=6.7.4 By: Tomi Mester https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-190922 Mon, 19 Oct 2020 20:28:29 +0000 https://data36.com/?p=1160#comment-190922 In reply to Tamas.

Got me! 😉

]]> By: Tomi Mester https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-190826 Mon, 12 Oct 2020 17:34:50 +0000 https://data36.com/?p=1160#comment-190826 In reply to Nipun Verma.

Thanks a lot Nipun!
PS. And actually, you can: by sharing this with your friends on social media! 😉

Cheers!

]]> By: Nipun Verma https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-190825 Mon, 12 Oct 2020 15:26:54 +0000 https://data36.com/?p=1160#comment-190825 This is amazing Tomi, Thanks a ton for all your efforts! can’t thank yoou enough man
🙂

]]> By: Tamas https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-73896 Sat, 13 Apr 2019 15:52:22 +0000 https://data36.com/?p=1160#comment-73896 All of these artists are from Sweden, except Luis Fonsi who are from Puerto Rico 😛 ;).

]]> By: Data Coding 101 - 4 more command line tools: sed, awk, join, date https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-68268 Thu, 21 Mar 2019 15:56:50 +0000 https://data36.com/?p=1160#comment-68268 […] is a command that will be very useful in SQL as well. But for now let’s stay with the command line. Here’s a little example. You can just follow […]

]]> By: Tomi Mester https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-67546 Mon, 18 Mar 2019 15:16:39 +0000 https://data36.com/?p=1160#comment-67546 In reply to Constance McCormick.

hey Constance,

good question and yes JOIN comes before WHERE.
The extended key-word-order-list looks like this
1. SELECT
2. FROM
3. JOIN (ON)
4. WHERE
5. GROUP BY
6. HAVING
7. ORDER BY
8. LIMIT
Hope this helps!
Cheers,
Tomi

]]> By: Constance McCormick https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-67393 Sun, 17 Mar 2019 20:15:43 +0000 https://data36.com/?p=1160#comment-67393 Hi Tomi,
Thanks for the article. I was referencing your “best practices” article while completing the exercises, specifically the ordering of key words. I’m assuming from your answer it is correct to put a JOIN clause before a WHERE clause? The “best practices” article didn’t state and I was putting my WHERE clause before my JOIN clause. Just wanted some clarification! Thank you!

]]> By: Tomi Mester https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-29090 Tue, 31 Jul 2018 16:50:18 +0000 https://data36.com/?p=1160#comment-29090 In reply to RYAN ALEJO.

Haha, thanks, Ryan! Spot on!

]]> By: RYAN ALEJO https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-26601 Fri, 13 Jul 2018 05:18:06 +0000 https://data36.com/?p=1160#comment-26601 Hi Tomi,

In Test yourself #2
Print the top 5 ABBA songs ordered by number of plays!

I think you forgot to put “LIMIT 5” in your answer.
Just incase in the future, ABBA creates new song again. =)

]]> By: Tomi Mester https://data36.com/sql-join-data-analysis-tutorial-ep5/#comment-11521 Fri, 16 Feb 2018 01:15:24 +0000 https://data36.com/?p=1160#comment-11521 In reply to Puneet.

hi Puneet,

for the first look, it seems that you are missing the GROUP BY clause, but just in case could you provide me the error message you received?

Thanks,
Tomi

]]>