ACCENTURE SQL INTERVIEW QUESTION | Friends categories

[@saktibiswal6445]

Thanks

[@Maturshab2210]

What if we do a group by?

[@parthchauhan9305]

DROP TABLE IF EXISTS friends;
CREATE TABLE friends
(
friend1 VARCHAR(50),
friend2 VARCHAR(50)
)
;
INSERT INTO Friends VALUES
("Robin","Rahul"),
("Prithvi","Rahul"),
("John","Rahul"),
("Rahul","Robin"),
("Rahul","Prithvi"),
("Rahul","John")
;
SELECT * FROM friends;