This lesson's interactive features are locked, please to keep using them

Namespacing on Tables

When working with multiple tables, you can specify which table a field belongs to using a .. For example:

table_name.column_name

SELECT students.name, classes.name
FROM students
INNER JOIN classes ON classes.class_id = students.class_id;

The above query returns the name field from the students table and the name field from the classes table.

Assignment

Adjust the query to:

Return the name and age fields from the users table.
Return the name field from the countries table and rename it to country_name.
Sort by country_name in ascending order.