You have the following table with sample data:

TABLE: employee$\_$t

Employee$\_$ID EmployeeFirstName EmployeeLastName Department$\_$ID Manager$\_$ID Salary Phone

$1$ Mary Jacobs $1630000285-8879$

$2$ Kenji Numoto $2635000287-0098$

$3$ Heather Jones $3630000287-9981$

$4$ Rosalie Jackson $1120000285-1273$

$6$ Steven King $5660000123-1212$

$7$ James Nestor $4630000333-4455$

$8$ Richard Wu $4725000333-2233$

$9$ Kim Sung $2225000111-1111$

$10$ John Smith $3330000122-2211$

Which query will show all employees who are managers? Select all that apply.

Question $4$ options:

SELECT $*$

FROM employee$\_$t

WHERE employee$\_$id $=($SELECT manager$\_$id FROM employee$\_$t$)$;

SELECT $*$

FROM employee$\_$t

WHERE employee$\_$id $=$ manager$\_$id ;

SELECT DISTINCT e$.*$

FROM employee$\_$t e LEFT JOIN employee$\_$t m

on e$.$employee$\_$id $=$ m$.$manager$\_$id ;

SELECT $*$

FROM employee$\_$t

WHERE employee$\_$id IN $($SELECT DISTINCT manager$\_$id FROM employee$\_$t$)$;