求上次的拜访时间

SELECT t1.ActualVisitID,t4.DepartmentName,t5.SaleAreaName,u.UserName,s.StoreName,s.StoreCode,t1.Visit_StartTime
,
--上次拜访时间
(SELECT  TOP 1 t2.Visit_StartTime FROM dbo.TPlaActualVisit t2 WHERE 
t2.StoreID = t1.storeid AND t2.UserID = t1.userid and
t2.Visit_StartTime < t1.Visit_StartTime) AS uptime
,
--这个月到达次数
(SELECT COUNT(ActualVisitID) FROM dbo.TPlaActualVisit t3 WHERE 
t3.StoreID = t1.storeid AND t3.UserID = t1.userid AND MONTH(Visit_StartTime) = MONTH(GETDATE())
) AS arrivecounts
FROM dbo.TPlaActualVisit t1
LEFT JOIN dbo.TBasStore AS s ON t1.StoreID = s.StoreID
LEFT JOIN dbo.TBasUserInfo AS u ON t1.UserID = u.UserID
LEFT join dbo.TBasDepartment t4 ON u.DepartmentID = t4.DepartmentID
LEFT JOIN dbo.TBasSaleArea t5 ON t5.SaleAreaID = s.SaleAreaID
WHERE MONTH(t1.Visit_StartTime) = MONTH(GETDATE())
ORDER BY t1.Visit_StartTime