Google: Common Friends Script
You are analyzing a social network dataset at Google. Your task is to find mutual friends between two users, Karl and Hans. There is only one user named Karl and one named Hans in the dataset.
The output should contain 'user_id' and 'user_name' columns.
This intermediate-level SQL interview question from Google is designed to assess your ability to manipulate and analyze complex relational databases, specifically focusing on finding mutual connections within a social network dataset.
Approach Hints:
Take the challenge! ??
Mastering such queries not only boosts your problem-solving skills but is also crucial in handling real-life data scenarios in tech roles, especially in companies like Google.
We encourage you to test out this query, tweak it, and maybe even optimize it. Understanding the underlying concepts will greatly enhance your SQL fluency and prepare you for similar challenges.
Happy querying!