Query to find names of all users who are not friends to each other : Friendship database contains two tables, one that keeps track of all the users, and one that maintains friendship relationships
between users


CREATE TABLE users (
    ID int,
    Name varchar(255)
);

CREATE TABLE friends (
    ID1 int,
    ID2 int
);
For each friendship there is exactly one entry in the friends table, containing the primary keys in users of the two friends.

And i want find names of all users who are not friends to each other