title: I separated my _type column while creating procedure but it's results are not true in MySQL workbench
body: <pre><code>CREATE DEFINER=`root`@`%` PROCEDURE `user_factors`(in users_id int)
  begin
  select u.id,count(f._type in (select f._type from factor as f where f._type=1)) as payed ,
   count(f._type in (select f._type from factor as f where f._type !=1)) as unpayed , count(f.id) as factor_count
  from users as u
  end
  </code></pre>
  <p>[It says that we have two _type s 1 &amp; 3 so when we call it we have to see one payed and one not <a href="https://i.stack.imgur.com/J2jr1.png" rel="nofollow noreferrer">but in second picture we see that it's filled both with 2 </a>payed]<a href="https://i.stack.imgur.com/s5Hyc.png" rel="nofollow noreferrer">2</a></p>