Count multiple rows based one one row : I think I'm just not getting search results as this should be answered somewhere here since I'm having trouble just typing a title.

My table looks like this:  

Name - Element -  City  
Design Inc - 51024 - New York  
Plant Corp - 51024 - Chicago  
Energy Ltd - 9665 - Boston

If I write  

Select Name, Element, City  
From Table  
Where City = 'New York'

Based on the Element, here it's the same value, I want the output to be a count of  
For New York  
Name = 2  
Element = 1  

The same output would be for Chicago. I'm having trouble with where clause because obviously if I put = to a city, all I get is one row. 

Thanks