plz i need help!!! sql

Question

JOIN, Table Operations

1.2 Practice

You are given the following students and teachers tables
students (with their teachers ID's):

Write a query to output all of the students with their teachers' last names in one table, sorted by students ID.

SELECT students.id, students.firstname, students.lastname,
students.teacherid AS teacher
from students, teachers
WHERE students.teacherid = teachers.lastname
ORDER BY sdudents.id

Answer 1

So it took a while but here is the actual code u need to complete this task:

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

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

Answer 3

select s.id, s.firstname, s.lastname, t.lastname as teacher from students s, teachers t where s.teacherid = t.id order by 1

Answer 4

select s.id, s.firstname, s.lastname, t.lastname as teacher from students s inner join teachers t on s.teacherid = t.id order by 1

Answer 5

Thanks for your time man i appreciate it very much

Answer 6

thanks to you, I can now calmly analyze everything and draw conclusions

Answer 7

SELECT DISTINCT subject
FROM teachers;

Answer 8

I think I get it now. I answer soon.

Answer 9

Oh my gosh 😂 it's WORKING WORKING BRO THANK YOU SO SO MUCH FOR YOUR HELP UNBELIEVABLE YOU DID IT

Answer 10

Wait a minuit, you need use JOIN! ;-)

Answer 11

Yes i heard about JOIN, INNER ... People says in sololearn they give old version of the solution

Answer 12

I memtioned it because you wrote originally "JOIN, Table Operations". See above. Anyway, don't mention it. No big deal.

Answer 13

SELECT students.id, students.firstname, students.lastname, teachers.lasname

FROM students, teachers

WHERE students.teacherid = teachers.id

ORDER By students.id

I know I am late, just delivering what I promised.

Answer 14

select s.id, s.firstname, s.lastname, t.lastname as teacher from students s inner join teachers t on s.teacherid = t.id order by 1

Answer 15

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

Try this dude

Answer 16

SELECT students.id, students.firstname, students.lastname, teachers.lasname

FROM students, teachers

WHERE students.teacherid = teachers.id

ORDER By students.id

Answer 17

None of these is the right answer

Answer 18

None of theses are the right answer, ive tried multiple times with many variations and nothing is working.

Answer 19

select students.id, students.firstname, students.lastname, teachers.lastname as teacher from students inner join teachers on students.teacherid=teachers.id order by id

Answer 20

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