-- Generated by ANTS Performance Profiler
-- Executed against (LocalDB)\v11.0
USE [C:\USERS\JON\ADVENTUREWORKSLT2012_DATA.MDF]

-- Executed query
SELECT TOP (10) 
    [Filter4].[CustomerID] AS [CustomerID], 
    [Filter4].[C1] AS [C1], 
    [Filter4].[CompanyName] AS [CompanyName], 
    [Filter4].[C2] AS [C2], 
    [Filter4].[C3] AS [C3]
    FROM ( SELECT [Project4].[CustomerID] AS [CustomerID], [Project4].[CompanyName] AS [CompanyName], [Project4].[C1] AS [C1], [Project4].[C2] AS [C2], [Project4].[C3] AS [C3], row_number() OVER (ORDER BY [Project4].[CustomerID] ASC) AS [row_number]
        FROM ( SELECT 
            [Project1].[CustomerID] AS [CustomerID], 
            [Project1].[CompanyName] AS [CompanyName], 
            CASE WHEN ([Project1].[Title] IS NULL) THEN N'' ELSE [Project1].[Title] END + CASE WHEN (CASE WHEN ([Project1].[Title] IS NULL) THEN N'' ELSE N' ' END IS NULL) THEN N'' WHEN ([Project1].[Title] IS NULL) THEN N'' ELSE N' ' END + [Project1].[FirstName] + N' ' + [Project1].[LastName] + N' ' + CASE WHEN ([Project1].[Suffix] IS NULL) THEN N'' ELSE [Project1].[Suffix] END AS [C1], 
            CASE WHEN ( EXISTS (SELECT 
                1 AS [C1]
                FROM [SalesLT].[SalesOrderHeader] AS [Extent3]
                WHERE [Project1].[CustomerID] = [Extent3].[CustomerID]
            )) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C2], 
            CASE WHEN ( EXISTS (SELECT 
                1 AS [C1]
                FROM [SalesLT].[SalesOrderHeader] AS [Extent4]
                WHERE [Project1].[CustomerID] = [Extent4].[CustomerID]
            )) THEN [Project1].[C1] ELSE cast(0 as decimal(18)) END AS [C3]
            FROM ( SELECT 
                [Extent1].[CustomerID] AS [CustomerID], 
                [Extent1].[Title] AS [Title], 
                [Extent1].[FirstName] AS [FirstName], 
                [Extent1].[LastName] AS [LastName], 
                [Extent1].[Suffix] AS [Suffix], 
                [Extent1].[CompanyName] AS [CompanyName], 
                (SELECT 
                    SUM([Extent2].[TotalDue]) AS [A1]
                    FROM [SalesLT].[SalesOrderHeader] AS [Extent2]
                    WHERE [Extent1].[CustomerID] = [Extent2].[CustomerID]) AS [C1]
                FROM [SalesLT].[Customer] AS [Extent1]
            )  AS [Project1]
        )  AS [Project4]
        WHERE (1 = [Project4].[C2]) AND (((LOWER([Project4].[CompanyName])) = (LOWER(N'bike'))) OR ((LOWER([Project4].[CompanyName]) IS NULL) AND (LOWER(N'bike') IS NULL)))
    )  AS [Filter4]
    WHERE [Filter4].[row_number] > 0
    ORDER BY [Filter4].[CustomerID] ASC