Suppose I have a tow SQL tables:
Fathers
id | name
-------------
1 | Clinton
2 | Gates
3 | Bush
4 | Clinton
Sons
id | fatherid | name
---------------------
1 | 1 | bill
2 | 1 | suzy
3 | 2 | mera
4 | 2 | suzy
5 | 3 | bill
6 | 3 | rose
7 | 4 | bill
** I would like to write a query that returns the Fathers who have (at least two sons) one of sons named bill and the other son is not suzy . How do I write this SQL query?**