Problem $2\mathrm{.}12$: Create a MANAGER table from the EMP table which should hold

details only about the managers.

Solution:

$1.$ Use CREATE as SELECT FROM syntax.

$2.$ from should include employee

$3.$ Use the where clause to filter out only managers.