Hi,
I actually was confronted with this same issue, and thought that maybe I was missing some rows for track names by using the track table as my FROM
clause.
So, I wanted to ask for examples on good practices to divert from this issue in the first place.
From the get go, ¿How should anyone compare the three tables to determine which one would be the best option to act as your FROM clause?, ¿What strategy should I use to achieve that when comparing tables with SQL?
I’ve been having a hard time not getting access to similar methods like .info
, .describe
and .value_counts
, that I used to apply when working with tables on Pandas. ¿Which would be a comparable set of tools when using SQL?
With my best regards for you all,
Esteban.
Screen Link: https://app.dataquest.io/m/190/building-and-organizing-complex-queries/3/the-with-clause
Reviewed Code: Wrong answer with changing order of tables in JOIN