title: sqlite - How do I select distinct row by date?
body: <p>I have a schema as follows:</p>
  
  <pre><code>CREATE TABLE fruit ( name TEXT, date_collected TEXT);
  </code></pre>
  
  <p>Data:</p>
  
  <pre><code>INSERT INTO fruit (name, date_collected) VALUES ('red apples', '2020-02-04 08:04:37+00:00');
  INSERT INTO fruit (name, date_collected) VALUES ('red apples', '2020-06-01 04:36:09+00:00');
  INSERT INTO fruit (name, date_collected) VALUES ('mangoes', '2020-03-18 19:14:24+00:00');
  INSERT INTO fruit (name, date_collected) VALUES ('mangoes', '2017-04-20 19:14:24+00:00');
  INSERT INTO fruit (name, date_collected) VALUES ('watermelon', '2019-12-20 14:29:02+00:00');
  </code></pre>
  
  <p>How do I select output that shows only the newest distinct fruit entries by date?</p>
  
  <p>e.g. </p>
  
  <pre><code>red apples | 2020-06-01 04:36:09+00:00
  mangoes | 2020-03-18 19:14:24+00:00
  watermelon | 2019-12-20 14:29:02+00:00
  </code></pre>