INNER JOIN SQL SERVER 2019 THREE TABLES

[DbmsKOS]

PRIMARY KEY VS FOREIGN KEYS SSMS (2019) EXPRESS

I have three tables at SQL SERVER 2019 described below:
Table DEPARTMENTS : Columns DeptID , DeptName example FINANCE, IT .
Table EMPLOYEE : Columns : employeeID , SupervisorID .
Table SUPERVISOR : Columns : FirstName, LastName, SupervisorID, DeptID .
HOW TO EXECUTE ON QUERY in SQL SYNTAX OF PRIMARY KEYS AND FOREIGN KEYS FOR THESE THREE TABLES???
THANK YOU DEAREST FRIENDS . YOUNG KOSOVAR CITIZEN FROM KOSOVO ..

0 rows affected how to fix it on INNER JOIN THREE TABLES To shown me example text Finance, HR ?

[Patrick]

This looks like a study or interview question. To get you started: What are the relationships between the tables? What are the candidates for primary and foreign keys.

[SASKiwi]

Where does SAS come into this?

[Sajid01]

The following tutorial should help you.

https://www.sqlshack.com/a-step-by-step-walkthrough-of-sql-inner-join/