title: How can I find the percentage of men and women in a certain building?
body: <p>Tables:</p>
  
  <pre><code>- Activities: id, userId, description, buildingId
  - Buildings: id, name
  - User: id, name, gender
  </code></pre>
  
  <p>Users can create activities for example: "checking mail" would be an activity, the buildingid links to a building where a certant activity is going on.</p>
  
  <p>What I need is a query that will get the % male/female per building, based of the amount of activities going on at such building.</p>
  
  <p>For example:</p>
  
  <pre><code>User: 1, mike
  Building: 1, main hall
  
  Activities:
  
  id: 1
  userId: 1 (mike)
  description: "checking mail"
  buildingId: 1 (main hall)
  
  id: 2
  userId: 1 (mike)
  description: "getting coffee"
  buildingId: 1 (main hall)
  </code></pre>
  
  <p>So I want to get the % female / male of the building 1 (main hall) how can I do this the best way?</p>