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