[Question] Why do I have the Wrong Platform?

Question: You have written the query below, using the attached all_users and all_platforms table. The goal of this query is to break down the users by platform and source, only focusing on those from the android platform. For reference, the all_platforms table is pasted below.

 

select
 platform
 , source
 , count(*)
from
 all_users
where
 platform = (
   select
     platform
   from
     all_platforms
   limit 1
 )
group by
 1
 , 2

But wait, I’m seeing that all the platforms are showing up as “web.”

 

How can we correct this?


Ready for the solution? Click here!

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