-- Where does scribe Misenplis work?
select Team.WorkPlace
from
	Worker inner join Team on Worker.Team_ID = Team.ID
where
	Worker.Name = 'Misenplis'
;

-- What are the teams working near the Nile?
select Team.ID
from Team
where
	Team.WorkPlace = 'Nile banks'
;

-- What is the composition (name, ID, job) of the teams assigned to the north?
select Worker.Name, Worker.ID, Worker.Job
from
	Worker inner join Team on Worker.Team_ID = Team.ID
where
	Team.WorkPlace = 'North'
;
