title: Querying multiple columns in a database and finding their sum
body: <p>I have school application data-table that looks like this...</p>
  
  <pre><code>create table todel (user_id int, SchemesApplicable1 int, SchemesApplicable2 int, 
  SchemesApplicable3 int, SchemesApplicable4 int);
  
  insert into todel values (1, 1, 0, 1, 0);
  
  insert into todel values (2, 0, 0, 0, 0);
  
  insert into todel values (3, 1, 0, 1, 0);
  
  insert into todel values (4, 1, 0, 0, 0);
  
  insert into todel values (5, 1, 0, 1, 1);
  
      SELECT Count(User_Id) as No_Off_Application , 
   sum(if(SchemesApplicable1 = 1, 1, 0)) as first,
  sum(if(SchemesApplicable2 = 1, 1, 0))  as second, 
  sum(if(SchemesApplicable3 = 1, 1, 0))  as third, 
  sum(if(SchemesApplicable4 = 1, 1, 0))  as forth 
  FROM todel
  </code></pre>
  
  <p>The above query will return a report like this...</p>
  
  <pre><code>No_Off_Application  first   second  third   forth
  5   4   0   3   1
  </code></pre>
  
  <p>I will like to add one more column with the applicants who have applied for more than one scheme.
  The expected count is 3 (user id's 1, 3 and 5) 
  How do I write a query for this?</p>