MySQL - no subqueries, no right join - Solved with group by
\nselect s.name\nfrom\nsalesperson s\nleft join orders o on (o.sales_id=s.sales_id)\nleft join company c on (o.com_id=c.com_id)\ngroup by s.name\nhaving count(o
```\nselect s.name\nfrom\nsalesperson s\nleft join orders o on (o.sales_id=s.sales_id)\nleft join company c on (o.com_id=c.com_id)\ngroup by s.name\nhaving count(order_id)=0 or not sum(c.name=\'RED\')>0\n```
[]