I have the following query select id, organization1, organization2 from project
And the corresponding data
As you can see sometimes organization2 doesn’t have data the same for organization1
I need to perform a sql query that does the following:
Select case when Organization1 is not null take into account Organization 1 else take into Organization2 as OrganizationRevised. If both are not null take into account Organization 1
Select just level2.level3 of OrganizationRevised
Id Organization Revised
Thank you for your help.