/* TWO TABLES OR MORE */

/* Show the full team name and students on each team. Sort by team.  */
select team_name, teams.teamid, stdfname, stdlname
from team, students
where teams.teamid = students.std_teamID
order by teamID;

/* WHERE Clause */
select team_name, teams.teamID, stdfname, stdlnamefrom team, students
WHERE teams.teamid = students.std_teamId
order by teamID;

/* JOIN Operator in FROM clause */ 
select team_name, teams.teamID, stdfname, stdlname
from teams INNER JOIN student ON teamID = std_teamID 
order by teamID;

/* Join with the JOIN operator in the FROM clause. */
select team_name, teams.teamID, stdid, stdfname, stdlname,  evalsemester, evalyear, eval_ID
from teams join students on teams.teamID = students.std_teamid
join evaluations on students.stdid = evaluations.evaluateeID
order by teamID, stdid;

/* Show team name, teamd ID, student ID and name, semester,
year and evaluation ID for each student who was evaluated (evaluatee).  */
select team_name, teams.teamID, stdid, stdfname, stdlname, evalsemester, evalyear, eval_ID
from teams join students on teams.teamID = students.std_teamid
    join evaluations   on students.stdid = evaluations.evaluateeID
order by teamID, stdid;

/* Join in the WHERE clause */
select team_name, teams.teamID, stdid, stdfname, stdlname, evalsemester, evalyear, eval_ID
from teams, students, evaluations
where teams.teamID = students.std_teamID
and students.stdid = evaluations.evaluateeID
order by teamID, stdid;