Department name based on block number
Write a query to display the names of the departments in block number 3. Sort the records in ascending order.
(HINT: Use department table to retrieve records.)
Solution:
SELECT DEPARTMENT_NAME FROM DEPARTMENT WHERE DEPARTMENT_BLOCK_NUMBER=3 ORDER BY DEPARTMENT_NAME;
