Hi, could you please help me solve the following query using the syntax of Oracle SQL developer.

Report all vendor_name. If they have a cooperating_vendor_id(which is not null), report their name as 'N/A' if it's null

No com Connection_1.sql * VENDORS * Columns Data | Model Constraints Grants Statistics Triggers | Flashback | Dependencies Details | Partitions Index Actions... 4 COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 4 COLUMN_ID COMMENTS 1 VENDOR_ID NUMBER (null) 1 (null) 2 VENDOR NAME VARCHAR2(50 BYTE) No (null) 2 (null) 3 VENDOR_ADDRESS1 VARCHAR2(50 BYTE) Yes (null) 3 (null) 4 VENDOR_ADDRESS2 VARCHAR2(50 BYTE) Yes (null) 4 (null) 5 VENDOR_CITY VARCHAR2(50 BYTE) No (null) 5 (null) 6 VENDOR_STATE CHAR(2 BYTE) No (null) 6 (null) 7 VENDOR_ZIP_CODE VARCHAR2(20 BYTE) No (null) 7 (null) 8 VENDOR_PHONE VARCHAR2(50 BYTE) Yes (null) 8 (null) 9 VENDOR_CONTACT_LAST_NAME VARCHAR2(50 BYTE) Yes (null) 9 (null) 10 VENDOR_CONTACT_FIRST_NAME VARCHAR2(50 BYTE) Yes (null) 10 (null) 11 DEFAULT_TERMS_ID NUMBER No (null) 11 (null) 12 DEFAULT_ACCOUNT_NUMBER NUMBER No (null) 12 (null) 13 COOPERATING_VENDOR_ID NUMBER Yes (null) 13 (null)