Using the Demo Database, write a SQL* statement to select all the employees that have registered (sales) more than 10 orders. It should be able to list 1) last and first names of the employees, and 2) the total number of orders the employees registered. Print out SQL statement and results. Put the SQL statement and result here.

1. solved SELECT employees.employeeid, firstname, lastname, count(orders.employeeid) as sales FROM employees LEFT JOIN orders ON Orders.employeeID=employees.employeeID GROUP by orders.employeeid having count(orders.employeeid)>10 ;

2. need help (I think the answer is 190) SELECT sum(orders.employeeid) FROM employees LEFT JOIN orders ON Orders.employeeID=employees.employeeID GROUP by orders.employeeid having count(orders.employeeid)>10 ;