title: "ORA-00923: FROM keyword not found where expected"
body: <p>I am getting the following error</p>
  
  <blockquote>
    <p>"ORA-00923: FROM keyword not found where expected" while executing the query  </p>
  </blockquote>
  
  <pre><code>SELECT 
      count(pf.pref_selection) filter ( WHERE pc.collection = "players")      OVER (partition BY pc.collection,pc.user_id )  AS Avg_players        
      count(pf.pref_selection) filter ( WHERE pc.collection = "teams")        OVER (partition BY pc.collection,pc.user_id )  AS Avg_teams  
  FROM NBA_OWNER.PREFERENCES pf 
  inner join NBA_OWNER.PREF_COLLECTIONS pc on pc.ID=pf.COLLECTION_ID 
  where pc.LAST_UPDATE_DATE&gt;"30-SEP-16'`
  </code></pre>