Question

Write a query to display the names of the departments in block number 3. Sort the records in ascending order.

Answer 1

Answer:

select department_name from department where department_block_number=3 order by department_name asc;

Explanation:

We select the department_name from department relation and add condition that department belongs to block number 3 and order it in ascending order.