Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Get to know the data
2. Get to know the room table
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
Aliases for tables

Instruction

All right! As you can see, there are four columns in the room table: id, room_number, beds, and floor.

The column:

  • id is the identification number of the room in our table.
  • room_number is the number of the room typically found on its door in the dormitory.
  • 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.

Let's get started!

Exercise

Study the contents of the room table, and click I'm done. Next exercise.