Event Friends Recommendation

Problem You are given two tables: friendship and event_rsvp. friendship Column Name Type user1_id int user2_id int The composite primary key is (user1_id, user2_id). Every friendship row is stored with the condition user1_id < user2_id, and the relationship is two-way. event_rsvp Column Name Type user_id int event_id int event_type varchar(255) attendance_status varchar(255) start_date date end_date date The composite primary key is (user_id, event_id). Your task is to find…