title: PostgreSQL - MAX() from upcoming dates
body: <p>I am trying to write a query which will show me what is the maximum value starting from a date.</p>
  <p>Example:</p>
  <pre><code>╔════════════╦═══════╦═══════════════╗
  ║    date    ║ value ║ max uplcoming ║
  ╠════════════╬═══════╬═══════════════╣
  ║ 01/01/2020 ║  3000 ║          4000 ║
  ║ 02/01/2020 ║  3000 ║          4000 ║
  ║ 03/01/2020 ║  3000 ║          4000 ║
  ║ 04/01/2020 ║  4000 ║          4000 ║
  ║ 05/01/2020 ║  4000 ║          3000 ║
  ║ 06/01/2020 ║  2000 ║          3000 ║
  ║ 07/01/2020 ║  2000 ║          3000 ║
  ║ 08/01/2020 ║  3000 ║          3000 ║
  ║ 09/01/2020 ║  3000 ║          2000 ║
  ║ 10/01/2020 ║  2000 ║          2000 ║
  ║ 11/01/2020 ║  2000 ║          1000 ║
  ║ 12/01/2020 ║  1000 ║          1000 ║
  ║ 13/01/2020 ║  1000 ║               ║
  ╚════════════╩═══════╩═══════════════╝
  </code></pre>