title: mysql: remove rows with repeated values with condition (repeated columns)
body: <p>I have a table "player" as follow
  where:
  ID is primary key.</p>
  
  <ul>
  <li>date = date they play (just for 1 month, so could from 1 to 31)</li>
  <li>Name =  name of the players</li>
  <li>Sport = sport they play and there can be many sports in the list; but i only focus on the one who play "football" and play more than 2 games in one day</li>
  </ul>
  
  <p>This is the table "player".</p>
  
  <pre><code>+----+------------+-------+-------------+
  | ID | Date       | Name  | Sport       |
  +----+------------+-------+-------------+
  |  1 |          1 | A     | football    |
  |  2 |          1 | A     | soccer      |
  |  3 |          3 | A     | tennis      |
  |  4 |          2 | B     | tennis      |
  |  5 |          2 | B     | football    |
  |  6 |          1 | C     | basketball  |
  |  7 |          1 | C     | tennis      |
  |  8 |          1 | C     | fishing     |
  |  9 |          4 | D     | football    |
  +----+------------+-------+-------------+
  </code></pre>
  
  <p>I want to find list of the people (name and sport) who DO NOT:</p>
  
  <ul>
  <li>practice "football" + other sport(s) in one day. </li>
  </ul>
  
  <p><strong>note</strong>: if someone who play "football" + other game(s) in one day, we remove him from the list for that day. only remove him for that particular day.</p>
  
  <p>So the result should be like this,</p>
  
  <pre><code>+----+------+------+-----------+
  | ID | Date | Name |  Sport    |
  +----+------+------+-----------+
  |  3 |    3 | A    | tennis    |
  |  6 |    1 | C    | basketball|
  |  7 |    1 | C    | tennis    |
  |  8 |    1 | C    | fishing   |
  |  9 |    4 | D    | football  |
  +----+------+------+-----------+
  </code></pre>
  
  <p>This is the follow up problem listed 
  <a href="https://stackoverflow.com/questions/32706960">mysql: find rows with repeated values plus condition</a> </p>
  
  <p>thank you for helping ! </p>