Which of the following queries corresponds to finding the name and number of employees in each department?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Select a query to display the number of employees in department number 30. Consider the following relation ...
- Select a query to display the number of departments in employee table. Consider the following relation sche...
- Select a query to display the number of people in each job. Consider the following relation schema ..... EM...
- SELECT name,salary , dept FROM emp e WHERE NOT EXISTS (SELECT 1 FROM dept WHERE deptno = e.dept); Which emp...
- Select a query to display the employee name and it's manager number. Consider the following relation schema...
- Select a query to display the employee name, employee number and manager name along with the manager number...
- Select a query to display the number of employees who can earn commission in department number 30. Consider...
- What will be the output of the following query? select count(*) from employees e1, e2, department d where e...