Twitter Interview Question for Software Engineers
- -1of 1 vote
Employees Per Department- aonecoding September 05, 2017 in United States
Twitter Interview Online Test SQL
A company uses 2 data tables, Employee and Department, to store data about its employees and departments.
Table Name: Employee
Table Name: Department
View sample tables:
Write a query to print the respective Department Name and number of employees for all departments in the Department table (even unstaffed ones).
Sort your result in descending order of employees per department; if two or more departments have the same number of employees, then sort those departments alphabetically by Department Name.
| Report Duplicate | Flag | PURGE
Twitter Software Engineer SQL
Interview Type: Written Test
Open Chat in New Window