Can you solve number 5 only?

Program the following queries in the sQL 1. List the names of those doctors whose specialty is Radiology. 2. List the names, registration number, and bed number of all male patients in ward 2 of Northwestern Hospital List the names of those patients whose diagnosis type is Cardiac arrest and who are not staff member List the names of those doctors who are working at more than one hospital List the names of those doctors who serve all the hospitals 3. 4. 5. HOSPITAL Address hospital-code name phone-no num-of-beds General Northwestern Evanston 45 Brunswick 923-5411 412 18 869-5578 500 STAFF hospital-code ward-code duty name Domb B 18 Holmes D. 22 Intern Nurse 18300 Bell G Food-Service 12600 Newport C. 22 Ritchie G. 22 Karplus W. 18 Anderson R. 18 Intern urse Intern Orderly 17000 20200 18300 12600 DIAGNOSIS registration-num diagnosis-code diagnosis-type DOCTOF speciality Miller G. Gynecology Ashby W. Radiology Ashby W. Radiology Stone C. Psychiatry Stone C. Psychiatry hospital-code name 18 74835 64823 36658 18004 Cardiac arrest Cardiac arrest Cardiac arrest Cancer 14 PATIENT Lee A. A. Radiology: address birthdate sex registration-num name Rasky P. 60 Bathurst Jun 1 1945 M Domb B. 55 Pia Apr 8 1954 M Fraser A. 11 MasseyMay 3 1960 F Bower E. 15 Ontario Oct 16 1933 M hiu w. | 14 Ivy -Jan 22 1966?- Lee A. 80 Lawton Oct 14 1962 M Ashby W. 40 Donora Jul 9 1966 F Adams C. 65 Hasley Nov 3 1949 F 18 18 Radiology Adams C. Radiology 63827 36658 64823 74835 18004 39217 24024 38702 OCCUPANCY registration-num hospital-code ward-code bed-num 36658 74835 18004 63827 64823 18 18 18