title: Subquery where I can count number of times a name appears from the first query
body: <p>This is the current code I have:</p>
  
  <pre><code>select Name, ECU, Identifier, Value, Max(Filetime) as "Filetime"
  from dbo.view_1
  where ECU='EBS7' and Identifier='88' and Value='2459579' or identifier ='87' and Value='2431629'
  group by Name, ECU, Identifier, Value
  ORDER BY
      MAX(Name) ASC 
  </code></pre>
  
  <p>This is the result I get: <a href="https://i.stack.imgur.com/EvQqb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EvQqb.png" alt="Result of query"></a></p>
  
  <p>I would like some kind of subquery or something that counts how many times a name appears. We can see that Agon appears two times and Apollo Akka appears only once.</p>
  
  <p>Any tips on what I should write?</p>