Scribd
Upload
15 views3 pages

SQL Question

Hqqo0q ahahaoqwbbsuTavbamlIWb2wwhRsa sisishab

Uploaded by

tsnakkjbbbr
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
15 views3 pages

SQL Question

Hqqo0q ahahaoqwbbsuTavbamlIWb2wwhRsa sisishab

Uploaded by

tsnakkjbbbr
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
t any employees or not. The results should high to low by number of employees, and then alphabetically by department when departments have the same number of employees. The results should list the department name followed by the employee count. The column names are not tested, so use whatever is appropriate. EMPLOYEE T . Name | Type Deserntar | string | “Department location. nt EMPLOYEE ID | NAME | SALARY | DEPT_ID 2 me hd 1 | Candice | 4685 1 2| Julia 2559 2 | | | | 3] Bob 4405 4 | | 4 scarlet 350 iis na | | P® Type here to search NAME LOCATION Executive Sydney 2 | Production Sydney | 3 Resources | Cape Town 4 Technical Texas 5 | Management Paris Sample Output Executive 2 Technical 2 Production 1 Management 0 Resources 0

You might also like