SELECT TOP (5) 
    [Project2].[CustomerID] AS [CustomerID], 
    [Project2].[CompanyName] AS [CompanyName], 
    [Project2].[C1] AS [C1]
    FROM ( SELECT [Project2].[CustomerID] AS [CustomerID], [Project2].[CompanyName] AS [CompanyName], [Project2].[C1] AS [C1], 
	row_number() OVER (ORDER BY [Project2].[CompanyName] ASC) AS [row_number]
        FROM ( SELECT 
            [Extent1].[CustomerID] AS [CustomerID], 
            [Extent1].[CompanyName] AS [CompanyName], 
            CASE WHEN ([Extent1].[Title] IS NULL) THEN N'' ELSE [Extent1].[Title] END + N' ' 
	             + [Extent1].[FirstName] + N' ' 
	  + CASE WHEN ([Extent1].[MiddleName] IS NULL) THEN N'' ELSE [Extent1].[MiddleName] END + N' ' 
		     + [Extent1].[LastName] + N' ' 
	  + CASE WHEN ([Extent1].[Suffix] IS NULL) THEN N'' ELSE [Extent1].[Suffix] END AS [C1]
            FROM [SalesLT].[Customer] AS [Extent1]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM [SalesLT].[SalesOrderHeader] AS [Extent2]
                WHERE [Extent1].[CustomerID] = [Extent2].[CustomerID]
            )) AND ([Extent1].[CompanyName] LIKE N'%Bike%')
        )  AS [Project2]
    )  AS [Project2]
    WHERE [Project2].[row_number] > 0
    ORDER BY [Project2].[CompanyName] ASC