SQL queries, SELECT statement. how to connect three tables and display data from them?

Question

SQL

Hello, please help me with this request.
It is necessary to display in the query the names of students from the specialties "Management", "Economics", and the faculty in which students study. Sort students by faculties, specialties, surnames.
STUDENT With fields NMZ (primary key) KOD_S, F, I, O, STIP, BALL
NMZ - record book number
F - student's last name
I - student's first name
O - student's middle name
STIP - scholarship
BALL -
Specialty exam
score KOD_S primary key, KOD_F , NAZVANIE_S
KOD_S - specialty code
KOD_F - faculty code
NAZVANIE_S - specialty name
FAKULTET
KOD_F primary key
KOD_S - specialty code
NAZVANIE_F - faculty name
Thank you in advance.

Answer 1

INNER JOIN? The student needs to add a new field for communication. Code of specialty or faculty.

Answer 2

And why is there a faculty code in the specialty, and a specialty code in the faculty?