/* Question a */
SELECT * FROM (SELECT * FROM [tableWarehouse] AS T LEFT JOIN [ItemType] AS I
ON T.[ItemTypeID] = I.[ItemTypeID])
ORDER BY [InTime] DESC;

/* Question b */
SELECT COUNT (Warehouse.ItemIDType) AS [ID COUNT]
FROM ItemType RIGHT JOIN Warehouse ON ItemType.ItemTypeID = Warehouse.ItemIDType
WHERE (((ItemIDType) = 45) AND OutTime IS NULL)
HAVING (DATEDIFF ('M', InTime, DATE()) >= 3);

/* Question c */
SELECT MAX (DateDifference) AS [Max_Date]
FROM (SELECT *,
LAG (InTime, 1) OVER (ORDER BY InTime DESC) AS [DateDifference]
FROM (SELECT Warehouse.InTime
FROM Warehouse
UNION
SELECT Warehouse.OutTime
FROM Warehouse
ORDER BY InTime DESC);