Best Friends List

Snapchat uses interaction frequency to determine a user’s "Best Friends." These are the people you communicate with most frequently on the platform.

Write an SQL query to find the top 3 friends that user_id 100 has interacted with most.

Rules:

• Consider only interactions where user_id is 100.
• Total interactions are calculated as the count of records for each friend_id.
• If multiple friends have the same interaction count, rank them by friend_id in ascending order.
• Output columns: friend_id, interaction_count.
• Return the results in descending order of interaction_count.

Table Schema:

• Interactions: interaction_id, user_id, friend_id, interaction_type (Snap, Chat, Story), created_at.