But what if the data we're looking for is stored over several tables? Like student and enrolled.

Tap on the table names.