[Question] Why is this join not working?
Question: Inspect the attached all_platforms and july_data tables (screenshots below for reference). Our goal is to list each platform, along with its associated number_of_plays for the month of July. If a platform is not in the july_data table, we can assume the number of gameplays is 0.
Currently, you have the query below, but it isn't showing the iOS and android fields despite the join. In fact, this result looks exactly like the july_data table.
select all_platforms.platform , july_data.number_of_plays from all_platforms join july_data on all_platforms.platform = july_data.platform
How can you modify this query to get the desired output