Need help understanding a Simple SQL query to retrieve data -


i having trouble creating sql query list names of manager(s) employee(s) handle less 2 orders.

here picture of database, tried put output of database, had trouble.

http://s22.postimg.org/spou700b5/printout.jpg

select o.name   employee e   join employee o on o.employeeid = e.managerid   left outer join ordert t on t.employeeid = e.employeeid   group o.name   having count(t.orderid) < 2