title: Apply where clause within count in sql
body: <pre><code>SELECT 
      Rooms.Building, 
      Count(Rooms.Room) AS TotalApartments, 
      Count(Rooms.Room) AS ApartmentsOccupied
  FROM 
      Rooms
  WHERE 
      (((Rooms.AssetType) &lt;&gt; 'LC')) 
  GROUP BY 
      Rooms.Building;
  </code></pre>
  
  <p>I want to count <code>Rooms.Room</code> Where <code>Rooms.Occupied = True</code> (<code>ApartmentsOccupied</code>) but when I put this clause into my sql it also applies the where to the TotalApartments column</p>