Question

A query to display the names of the department in lowercase and ordered in ascending order.Give an alias as dept_name

Answer 1

Answer:

select lower(department_name) as dept_name from department order by department_name;

this is 100% correct

Answer 2

ANS:

SELECT LOWER(Department_name) as dept_name from department order by dept_name;

Go and earn 100 points. LOL