$1.$ Write a query that JOINS all tables created in the previous lab to display the data in a similarformat to hospital$\_$basic. When you are joining your tables ensure that you are showing allrecords from the hospital$\_$record table including unmatched rows. You are not using the hospital$\_$basic table, but rather JOINing the physician,procedures, nurse, room, patient, and hospital$\_$record tables to output a table in the sameformat. Modify your column headers to match hospital$\_$basic.

$2.$ Modify your query from Question $1$ to only show rows with a valid physician, procedures,nurse, room, patient, and hospital$\_$record. $($Only matching rows$)$

$3.$ Rerun your query from Question $2$ order by AssistingNurse in descending order.

What would code be for these three?