Help needed to construct a SQL query
- by song202y
Need your help to get the list of suggested friends (who aren't friends of the current user but are friends of 2 or more of the current user's friends). The primary ordering should put people at the same school at the top, and the secondary ordering should put people with more common friends (that is, the number of people who are friends of that person and the current user) near the top.
Users:
user_id PK,
user_name
Profiles:
user_id PK,
school_name,
...
Friendships:
id PK,
user_id FK,
friend_id FK
Thank you in advance.
Joe