title: Combining last and first timestamp data of a group data in 1 row
body: <p>I have a screenshot table and I want to get the user screenshot time starts and screenshot time ends. I want to create a query to be able to export the data to provide to my users.</p>
  <p>Let's say this is my table data.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>scs_id</th>
  <th>scs_tracker_id</th>
  <th>created_at</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>1000</td>
  <td>2022-02-22 00:00:00</td>
  </tr>
  <tr>
  <td>2</td>
  <td>1001</td>
  <td>2022-02-22 04:00:00</td>
  </tr>
  <tr>
  <td>3</td>
  <td>1000</td>
  <td>2022-02-22 01:00:00</td>
  </tr>
  <tr>
  <td>4</td>
  <td>1002</td>
  <td>2022-02-22 12:00:00</td>
  </tr>
  <tr>
  <td>5</td>
  <td>1001</td>
  <td>2022-02-22 08:00:00</td>
  </tr>
  <tr>
  <td>3</td>
  <td>1000</td>
  <td>2022-02-22 02:00:00</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>My expected output should be:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>scs_tracker_id</th>
  <th>screenshot_starts</th>
  <th>screenshot_ends</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1000</td>
  <td>2022-02-22 00:00:00</td>
  <td>2022-02-22 02:00:00</td>
  </tr>
  <tr>
  <td>1001</td>
  <td>2022-02-22 04:00:00</td>
  <td>2022-02-22 08:00:00</td>
  </tr>
  <tr>
  <td>1002</td>
  <td>2022-02-22 12:00:00</td>
  <td>2022-02-22 12:00:00</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Code that I'm playing as of the moment:</p>
  <pre><code>SELECT 
  (SELECT MIN(created_at) FROM screen_shots GROUP BY scs_tracker_id ORDER BY scs_id ASC LIMIT 1) AS screenshot_starts,
  (SELECT MAX(created_at) FROM screen_shots GROUP BY scs_tracker_id ORDER BY scs_id DESC LIMIT 1) AS screenshot_ends
  FROM screen_shots
  </code></pre>