title: How to select only values for MAX(DATE)
body: <p>I have done similar SQL queries in my opinion already before but this is somehow impossible although sounds easy... I hope you can help me in this, I have checked multiple answers for relating questions finding no working solution. I'm using SQL Developer.</p>
  <p>I have two tables:</p>
  <p>FAMILY</p>
  <p><a href="https://i.stack.imgur.com/mWP2E.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mWP2E.png" alt="enter image description here" /></a></p>
  <p>and FAMILY_PLAN</p>
  <p><a href="https://i.stack.imgur.com/frBKq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/frBKq.png" alt="enter image description here" /></a></p>
  <p>And I need to find only the newest FAMILY_PLAN to each person. And the answer should be like this:</p>
  <p><a href="https://i.stack.imgur.com/LSMVU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LSMVU.png" alt="enter image description here" /></a></p>
  <p>Thank you for your help!</p>