select Office_num, LastName, FirstName
from Employee
where LastName = 'Dupont'
;

select EquipmentType.Description, Equipment.Description
from Employee, Equipment, EquipmentType
where
		Employee.LastName = 'Dupont'
and	Equipment.Employee_ID = Employee.Employee_ID
and	Equipment.EqpmtType_num = EquipmentType.EqpmtType_num
;

-- Other version with an inner join
select Equipment.Description, EquipmentType.Description
from
	Equipment 	inner join Employee on Equipment.Employee_ID = Employee.Employee_ID
						inner join EquipmentType on Equipment.EqpmtType_num = EquipmentType.EqpmtType_num
where Employee.LastName = 'Dupont';

select Technician.LastName
from Technician, CallOut, MadeCallOut, Equipment, EquipmentType
where
		Technician.Technician_ID = MadeCallOut.Technician_ID
and	MadeCallOut.CallOut_num = CallOut.CallOut_num
and	CallOut.StockTake_num = Equipment.StockTake_num
and	Equipment.EqpmtType_num = EquipmentType.EqpmtType_num
and	EquipmentType.Description = 'Communication' 
;
