Data explorer challenge: Generate list of members by location

Community Building Data & reporting
8

我曾有机会扩展唐的查询，为所有有位置的用户生成一个包含用户名、位置和电子邮件的列表。在某些情况下，这可能很有趣或有用：

SELECT u.username, u.locale, up.location, ue.email
    FROM users u
    LEFT JOIN user_profiles up ON u.id = up.user_id
    LEFT JOIN user_emails ue ON u.id = ue.user_id
    -- comment out WHERE clause for complete user list
    WHERE up.location <> ''
    ORDER BY up.location