Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. Get to know the Character table
So you think you can count?
Rounding functions and more
Review and practice


Let's introduce the table we'll use in this part of the course. If you love MMORPG games, you'll love this table, too. The table is named Character, and it stores information about characters in an online role-playing game. Each player can have more than one character.

Let's see what this table contains.


Select all columns from the Character table. Each character has its own unique Id and is associated with the ID of the user who created it. All characters have reached a certain Level, belong to a certain Class (e.g., wizard or warrior), and have some money (AccountBalance).

There are also stats like HP (health points), MP (mana points), Strength, and Wisdom. Due to various curses and blessings, characters' statistics can be affected by the StatModifier attribute, which can be positive or negative.

Finally, there is the Height and Weight of each character, expressed in meters and kilograms, respectively.