Data explorer challenge: Generate list of members by location

数据与报告
6

也许我不明白这个问题，但如果我明白了，那么

SELECT u.username
    FROM users u
    LEFT JOIN user_profiles up ON u.id = up.user_id
    WHERE location = 'Pakistan'

或者，同样地，

SELECT username from user_profiles, users
where user_id = id and location = 'Pakistan'

请注意，数据浏览器不接受双引号作为分隔符。