title: Calculating an "activation" percentage using SQL
body: <p>So I have the following SQL schema (<a href="http://sqlfiddle.com/#!2/b366c" rel="nofollow">http://sqlfiddle.com/#!2/b366c</a>) and what I'm trying to achieve is the % of companies that I can consider activated.</p>
  
  <p>In the schema, you can see there are the following tables</p>
  
  <ol>
  <li>organisations (otherwise known as companies)</li>
  <li>competitions</li>
  <li>competitionmembers</li>
  <li>activity_entries</li>
  </ol>
  
  <p>What I would like to do is, figure out the % of companies in the organisations (i.e. total users) that create a competition (competitions table), invite at least another person (competitionmembers table) and have completed at least one activity (activity_entries table)</p>
  
  <p>This may be too complex, but what I'd like to do is also create a funnel - to visualise where most companies drop off. For this, I understand I should create a seperate query for each of the steps and then just stack them to see the flow.</p>
  
  <p>Using the sample data provided here (<a href="http://sqlfiddle.com/#!2/b366c" rel="nofollow">http://sqlfiddle.com/#!2/b366c</a>) you can see that:
  <br><br>1. 4 companies have registered
  <br>
  2. 2 companies have created competitions
  <br>
  3. 1 company has a competition with at least 2 participants (not just the admin)
  <br>
  4. 1 company has registered at least one activity </p>
  
  <p>So 25% of companies became "activated".</p>
  
  <p>I would really appreciate some help in building these queries and visualising percentages!  </p>