title: Pairs of users with same set of followers
body: <p>I am still fairly new to mySQL and I am having a hard time making a query where I can find the users with the same set of followers.</p>
  <p>Here are my tables and for the subscribes table, my logic is that user1 subscribes to user2</p>
  <pre><code>CREATE TABLE user(
  user_id integer primary key auto_increment,
  username varchar(500) not null,
  email varchar(500) not null,
  password_hash varchar(500) not null,
  create_date date null
  );
  
  CREATE TABLE subscribes(
    subscribes_id INTEGER PRIMARY KEY AUTO_INCREMENT,
    user1_id INTEGER NOT NULL REFERENCES user,
    user2_id INTEGER NOT NULL REFERENCES user,
    FOREIGN KEY (user1_id) REFERENCES user (user_id),
     FOREIGN KEY (user2_id) REFERENCES user (user_id),
  INDEX (user1_id),
  INDEX (user2_id)
  );
  </code></pre>
  <p>Thank you</p>