title: Triple SELECT from the same table MySQL
body: <p>I'd like to group all these queries within the same table:</p>
  <pre><code>SELECT orgname, COUNT(username)
  FROM `user`
  GROUP BY orgname;
  
  SELECT COUNT(username) AS 'users_with_2FA'
  FROM `user`
  WHERE two_fa_enabled = 1
  GROUP BY orgname;
  
  SELECT COUNT(username) AS 'users_pending_2FA'
  FROM `user`
  WHERE two_fa_required_date IS NOT NULL AND two_fa_enabled IS NULL
  GROUP BY orgname;
  </code></pre>