title: MySQL Error Code 1111: Invalid use of group function
body: <p>I get error code 1111 when I try and print the celebrities who do not follow anyone. </p>
  
  <pre><code>user (email, password, name, date_of_birth, address, type)
  primary key(email)
  
  celebrity (email, website, kind)
  primary key(email)
  
  follow (follower,followee)
  primary key(follower,followee)
  foreign key(follower) references user(email)
  foreign key(followee) references user(email))
  
  SELECT DISTINCT(u.name)
  FROM follow as f, user as u, celebrity as c
  WHERE u.email = c.email and (0 &gt; COUNT(f.followee))
  ORDER by name DESC
  </code></pre>