Most Connected User by Accepted Requests

You are given accepted friendship request logs in table RequestAccepted.

Each row represents one accepted connection between two different users:

• requester_id: user who sent the request
• accepter_id: user who accepted the request
• accept_date: date of acceptance

Interpret each row as an undirected friendship edge. That means both requester_id and accepter_id gain one friend from that row.

Task:

• Return the user with the highest total number of friends.
• Return exactly these columns:
  • id: user id
  • num: friend count

The test data guarantees exactly one user has the highest friend count.

Supported submission environments:

• SQL (SQLite 3.27.2)
• Pandas (Python)