Get to know the data
2. Get to know the Room table
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
Aliases for tables

## Instruction

All right! As you can see, there are four columns in the table room: ID, RoomNumber, Beds, and Floor:

• ID identifies the rooms the room in our table.
• RoomNumber is the number of the room typically found on the door.
• Beds tells you how many beds there are in the room.
• Floor is the number of the floor where the room can be found in the dormitory.

Easy!

## Exercise

Study the contents of the table, and click when you're done.