Most Connected Co-Author

Problem

A research database records confirmed co-authorships between two researchers.

```
Coauthorship
+-------------+------+
| Column | Type |
+-------------+------+
| lead_id | int |
| partner_id | int |
| paper_date | date |
+-------------+------+
(lead_id, partner_id) is the primary key.
```

Each row means `lead_id` and `partner_id` co-authored a paper together, so both researchers gain one collaboration link. Find the researcher who has the most collaboration links. The test data guarantees exactly one such researcher.

Return that researcher's `researcher_id` and their number of links as `links`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns researcher_id, links.

Starter code (SQL)

SELECT *
FROM Coauthorship;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium