[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. 

all_platforms

 

july_data

 

Desired Output:

  

Problem: 

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


Ready for the solution? Click here!

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 8 mths agoLast active
  • 470Views
  • 1 Following