This error is showing.

Question

JOINING TABLES
SQL
SELECT students.id, students.name AS student, teachers.last_name AS teacher
FROM students
JOIN teachers ON students.teacherid = teachers.id
ORDER BY students.id;
: column students.name does not exist LINE 1: SELECT students.id, students.name AS student, teachers.last_... ^
The column name "name" does not exist in the "students" table. Use the correct column name or check if it exists in the table.

Answer 1

Read the error: Is there a column called name? Or is it firstname and lastname? (Or something else?)

Answer 2

Your question is...?

Answer 3

Open your DB and see the name of the column. Keep in mind while sql itself is case-insensitive, columns names 'name' and 'Name' are different.