I need help with practice 18.2 Mentors and Apprentice in SQL

Question

Please, I need help with this question I have been trying to solve this problem I have tried to get this but I keep getting errors. I don't know what I am doing wrong. Thanks

Answer 1

You only need to select teachers lastname as teacher, and the WHERE clause contains any specific condition not columns name, then you need to sort this data by student.id..

/********************
your code goes here

SELECT students.id, students.firstname, students.lastname, teachers.lastname AS teacher FROM students, teachers WHERE students.teacherid = teachers.id ORDER BY students.id;

Answer 2

Please show your attempt, so that we can help you

Answer 3

SELECT students.ID, students.firstname, students.lastname, teachers.firstname, teachers.lastname
FROM students, teachers
WHERE (students.ID, students.lastname,teachers.lastname) AS teacher

Answer 4

Thanks very much. You are awesome