title: Easiest way to get a total count and a count of a subset?
body: <p>I was trying to do this:</p>
  
  <pre><code>SELECT COUNT(*),
          (
              SELECT COUNT(*) FROM attend
              WHERE (DATEPART(WEEKDAY,start_date) = 2 OR DATEPART(WEEKDAY,start_date) = 6)
              AND empl_no = 12345
          )
          FROM attend as a
   WHERE empl_no = 12345
  </code></pre>
  
  <p>But this seems a little ugly.  Is there a better way to do this?</p>