Suppose Columbia University has two tables in their database:
The 'classes' table contains information on the classes that the school offers. Its primary key is 'id'. The 'students' table contains information on all students in the school. Its primary key is 'id'. It contains the foreign key 'class_id', which corresponds to the primary key of classes. Perform an inner join of classes and students using the primary and foreign keys described above, and select all the columns.
O SELECT *
O FROM classes
O JOIN students
O ON classes.id = students.class_id;