Question:
Resort Manager’s Details
Managements wants to know the manager of each resort.
Display resortid , resort name, manager name and his phone. Sort the output in ascending order of resort id. Give alias to manager name as MANAGERNAME and phone as PHONENO.
If manager is not available then display manager name ‘NA’. If phone number is not available then display as ‘NA’.

Code:
Main.sql
select resort.resortID, resort.resortName, nvl2(manager.name, manager.name, 'NA') as MANAGERNAME, nvl2(manager.phone, manager.phone, 'NA') as PHONENO from resort left join manager on resort.managerid=manager.managerid order by resort.resortID;
Hello to every , for the reason that I am truly keen of reading this webpage’s post
to be updated on a regular basis. It contains fastidious stuff.