SQL oracle with joining tables and Max functions
<p>Some help please? Just a noob here starting to learn how to write SQL and ran into this problem. I know how to use the <code>MAX</code> function but I can't figure out how to join all these requirements together. I have two tables, <code>Accounts</code> and <code>Books</code> (below is an example of the data)</p>

<pre><code>Accounts                                       
ID Series   YesorNot    Dated Filed     Plan Year       
1   123     Yes         06/12/2015      2015        
2   123     No          06/12/2015      2015        
3   145     Yes         06/06/2015      2015
4   145     No          02/02/2015      2014        
5   198     Yes         02/03/2015      2015        
6   187     Yes         02/14/2013      2013            
7   153     Yes         01/02/2011      2011        

Books       
Primary Key Date Created    ID
1           06/13/2015      123
2           06/12/2015      123
3           06/07/2015      145
4           02/02/2015      145
5           02/03/2015      198
</code></pre>

<p>Two tables: <code>Accounts</code> and <code>Books</code><br>
Looking for:<br>
1. Data that exists in both tables by the Project ID = Primary Key<br>
2. I only want one unqiue Series (Series also = ID)<br>
3. I want the <code>MAX</code> (most recent) value of Plan Year, and then if there are duplicates for Plan Year, I need the <code>MAX</code> (most recent) value of Date Created.<br>
4. I just need the columns <code>Project ID</code>, <code>Series</code>, <code>YesorNot</code>, <code>Date Filed</code>, <code>Plan Year</code> so my output should be like this:                          </p>

<pre><code>Project ID  Series  YesorNot  Dated Filed Plan Year     
1           123     Yes       06/12/2015  2015          
3           145     Yes       06/06/2015  2015          
4           145     No        02/02/2015  2014          
5           198     Yes       02/03/2015  2015  
</code></pre>