need to fix a where clause and an order by

SELECT DISTINCT dbo.tblLabourFiles.OpenDate AS [Date Opened], dbo.tblLabourFiles.CaseNum + N'/' + dbo.tblLabourFiles.CaseYear + N'/' + dbo.tblLabourFiles.Act AS [Case Number], dbo.tblCaseType.CaseType AS [Case Type], dbo.tblEmployerName.EmpName, DATEDIFF(dd, dbo.tblLabourFiles.OpenDate, GETDATE()) AS [Days Open], dbo.tblLabourFiles.Act FROM dbo.tblLabourFilesEmp INNER JOIN dbo.tblLabourFiles INNER JOIN dbo.tblCaseType ON dbo.tblLabourFiles.CaseTypeID = dbo.tblCaseType.CaseTypeID ON dbo.tblLabourFilesEmp.LabID = dbo.tblLabourFiles.LabID INNER JOIN dbo.tblSubEmployer ON dbo.tblLabourFilesEmp.SubEmpID = dbo.tblSubEmployer.SubEmpID INNER JOIN dbo.tblEmployerName ON dbo.tblSubEmployer.EmployerID = dbo.tblEmployerName.EmployerID CROSS JOIN dbo.tblEmployee WHERE (DATEDIFF(dd, dbo.tblLabourFiles.OpenDate, GETDATE()) > 100) AND (dbo.tblLabourFiles. ...