[leetcode][Database][Hard] 1919. Leetcodify Similar Friends

1 · ZhengWei, Liu · Dec. 16, 2022, 1:08 a.m.
Description Table: Listens +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | song_id | int | | day | date | +-------------+---------+ There is no primary key for this table. It may contain duplicates. Each row of this table indicates that the user user_id listened to the song song_id on the day day. Table: Friendship +---------------+---------+ | Column Name | Type | +---------------+---------+ | user1_id | int | | user2_id | int | +---------------+--...