Distinct Friend Requests
Distinct Friend Requests
Count the number of unique friend requests. Direction does not matter: a request from A to B and a request from B to A count as the same pair, and duplicate requests are counted once. Return a single column unique_requests.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| unique_requests |
|---|
| 6 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid