Question: Please help with oracle sql developer nunezsich4Exercise-Stuc Options Connect USB Device Send Ctri-Alt-Delete Versioning Migration Tools Help xerdse-Student.solntindass.sof SQL _Worksheet istory 01: Shou the list
nunezsich4Exercise-Stuc Options Connect USB Device Send Ctri-Alt-Delete Versioning Migration Tools Help xerdse-Student.solntindass.sof SQL _Worksheet istory 01: Shou the list of vendors who have ever issued invoices The result shou show vendor id, vendor name. The vendors that have issued aore than one invoice should be only shon once. 02: Show the vendors' detault account inforaation. The result should shou three colmns: vendor nane, vendor detault account nuaber, and account description. The result should sort the data by vendor nane tirst and then by account description. 03: Show the 1ist of our sanagers and their higher-level sanagers. The result should have tro colwns: "Hanaget nases" and "Higher-level aanager nase". The nanagers uho have no higher-level sanagers should not be shovn at all. Resits soret OutputEaplain Autotrace oeMS Output owA Cutpout Resuts: eslch4Exercise-Stuc ( Options-Connect SB Device"SendCtrl rsioning Migration Tools Help - Alt - Delete SQL Worksheet History Show the Aist ot vendors tho have ever issued invoices. The kesult shou show vendoz id, vendor nane The vendors that have issued more than one nvoice should be only shoum once Show the vendors default account infornation The reault should shou three coluana: vendor mane vendo: defauid account mber and account description. The result should sort the data by vendor hane kitot and then by account description. 03: Shor the l1st of our nanagers and thest ba cherilevel managexs The result should have two colunns: "Hanager nanee and THigher level uanager naae" The manager, who have no higher-level managers should not be shoun at all. ResislaScript Output clan! rtotrace Results: OWA
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
