Given the tables:

STUDENT$($StudentID$,$ StudentName, AdvisorID$)$

and

ADVISOR$($AdvisorID$,$ AdvisorName, Office, Phone$)$

which of the following SQL clauses would be used to implement a join between the two tables? The primary key column in the above are underlined. The foreign key column is italicized.

Group of answer choices

FROM Student JOIN Advisor ON Student.AdvisorID $=$ Advisor.AdvisorID

FROM Student JOIN Advisor

FROM Student.AdvisorID JOIN Advisor.AdvisorID

FROM Student JOIN Advisor on AdvisorID $=$ AdvisorID