title: SQL create view statement
body: <p>I am new to SQL Developer. I have to create a view to approach
  the sample output list below:</p>
  
  <p><a href="https://i.stack.imgur.com/eC65g.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eC65g.jpg" alt="enter image description here"></a></p>
  
  <p>The table structure is: </p>
  
  <pre><code>SITE(Site_ID, Region, Description, Latitude, Longitude, Altitude); 
  MEASUREMENT(Site_ID, Recorded_On, Name, Value, Outlier_Indicator);
  </code></pre>
  
  <p>Here is my script, it is working as I followed the advices.</p>
  
  <pre><code>create view Site_Outlier_Incidents AS 
      select 
          Site_ID, Name, Outlier_Indicator,
          count (SITE.Site_ID) as Number_Of_Incidents
      from Site SITE
      left join Measurement MEASUREMENT on MEASUREMENT.site_ID = SITE.Site_ID
      where Name = 'E.Coli'
      group by
          Site_ID, Name, Outlier_Indicator;
  </code></pre>