Question

Write a query to display the names of all staff from IT Department ordered in ascending order. ( Refere to the Below Schema )

Answer 1

Answer:

SELECT staff name FROM staff  

WHERE department id  

IN (SELECT department id FROM departments WHERE department name='IT')

ORDER BY staff name;

Explanation:

use under score between:

1 staff and name

2 department and id

3 department and name