Tables: department, dept_emp, dept_manager, employees, salaries, titles department (columns): dept_no, dept_name dept_emp (columns): emp_no, dept_no, from_date, to_date dept_manager (columns): emp_no,...


Tables:<br>department, dept_emp, dept_manager, employees, salaries, titles<br>department (columns): dept_no, dept_name<br>dept_emp (columns): emp_no, dept_no, from_date, to_date<br>dept_manager (columns): emp_no, dept_no, from_date, to_date<br>employees (columns): emp_no, birth_date, first_name, Last_name, gender, hire_date<br>salaries (columns): emp_no, salary, from_date, to_date<br>titles (columns): emp_no, title, from_date, to_date<br>a) Your task is to write a SQL query to find count of employee who does not<br>have a manager in the above given table schema?<br>

Extracted text: Tables: department, dept_emp, dept_manager, employees, salaries, titles department (columns): dept_no, dept_name dept_emp (columns): emp_no, dept_no, from_date, to_date dept_manager (columns): emp_no, dept_no, from_date, to_date employees (columns): emp_no, birth_date, first_name, Last_name, gender, hire_date salaries (columns): emp_no, salary, from_date, to_date titles (columns): emp_no, title, from_date, to_date a) Your task is to write a SQL query to find count of employee who does not have a manager in the above given table schema?

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here