Write a query to display the names of all staff from IT Department ordered in ascending order.

Question

Write a query to display the names of all staff from IT Department ordered in ascending order.

in progress 0
Isabelle 2 months 2021-08-02T05:02:21+00:00 2 Answers 0 views 0

Answers ( )

    0
    2021-08-02T05:03:22+00:00

    Answer: SELECT name

                   FROM employees

                   WHERE department_id = “IT”

                   ORDER BY  department_id  ASC;

    Explanation: It will check for department_id and if it is in IT then print the names in ascending order.

    0
    2021-08-02T05:04:10+00:00

    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

Leave an answer

Browse

9:3-3+1x3-4:2 = ? ( )