Write a query that JOINS two tables and returns all physicians as well as their respective departments. Sort the results by physician id in ascending order.

Your output should look like this:

$\backslash$table$[[$id$,$name,department$],[1,$John Dorian,General Medicine$],[2,$Elliot Reid,General Medicine$],[3,$Christopher,Surgery$],[4,$Turk,$],[5,$Percival Cox,General Medicine$],[,$Bob Kelso,General Medicine$]]$

Write a query that JOINS two tables to list all of the rooms and the number of hospital records that took place in each. The results should include the room number, room type, and the number of records. The query should select all rows in the room table so rooms that were unused $($Unmatched rows$)$ are listed in the output as well. Sort the results by room number.

Your output should look like this:

$\backslash$table$[[$number$,$roomType,floor,block,Times Used$],[101,$Double,$1,$A$,3],[102,$Double,$1,$A$,3],[103,$Triple,$1,$A$,0],[111,$Single,$1,$B$,3],[112,$Single,$1,$B$,4],[113,$Double,$1,$B$,1]]$