Question 6: Consider the following relational schema:\ Employee(<u>em…

1a. SELECT first_name FROM Employee WHERE first_name LIKE 'J_____';
2b. SELECT first_name FROM Employee WHERE first_name LIKE 'J_____%';
3c. SELECT dept_id, COUNT(emp_id) FROM Employee GROUP BY emp_id;
4d. SELECT dept_id, COUNT(emp_id) FROM Employee GROUP BY dept_id;
5e. SELECT DISTINCT d.dept_name FROM Department d INNER JOIN Manager m
6   ON d.mngr_id = m.mngr_id WHERE m.mngr_name = 'Brown';
7f. SELECT DISTINCT d.dept_name FROM Department d, Manager m WHERE
8   d.mngr_id = m.mngr_id AND m.mngr_name = 'Brown';