Make sure there is no error in coding and attach snippets of your query and output

Q$2.$ The table employee is given below.

TABLE : EmpSalary

Write an Oracle SQL query to display emp id$,$ designation, salary of the employees. The output first

based on the employee designation in ascending order, and for same benefits and designation the

highest salary will come first.

Q$3.$ List the departments which is location id greater than $1700$ and also List the departments which

department name is Construction

DEPARTMENT$\_$ID DEPARTMENT$\_$NAME

MANAGER$\_$IO LOCATION$\_$ID