Database: store_1
Question: Which employee manage most number of peoples? List employee's first and last name, and number of people report to that employee.
SQL:
SELECT T2.first_name , T2.last_name ,  count(T1.reports_to) FROM employees AS T1 JOIN employees AS T2 ON T1.reports_to = T2.id GROUP BY T1.reports_to ORDER BY count(T1.reports_to) DESC LIMIT 1;