SELECT
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'NO'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted > 0
        THEN 1
        ELSE 0
    END) AS completed_exported___NO,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'NO'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted = 0
        THEN 1
        ELSE 0
    END) AS completed___NO,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'NO'
        AND CHARINDEX('assigned', siw.WorkflowStatus) > 0
        THEN 1
        ELSE 0
    END) AS assigned___NO,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'NO'
        AND CHARINDEX('rcv applics', siw.WorkflowStatus) > 0
        THEN 1
        ELSE 0
    END) AS not_assigned___NO,SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'FI'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted > 0
        THEN 1
        ELSE 0
        END) AS completed_exported___FI,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'FI'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted = 0
        THEN 1
        ELSE 0
        END) AS completed___FI,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'FI'
        AND CHARINDEX('assigned', siw.WorkflowStatus) > 0
        THEN 1
        ELSE 0
    END) AS assigned___FI,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'FI'
        AND CHARINDEX('rcv applics', siw.WorkflowStatus) > 0
        THEN' 1
        ELSE 0
    END) as not_assigned___FI,SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'SE'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted > 0
        THEN 1
        ELSE 0
    END) as completed_exported___SE,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'SE'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted = 0
        THEN 1
        ELSE 0
    END) as completed___SE,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'SE'
        AND CHARINDEX('assigned', siw.WorkflowStatus) > 0
        THEN 1
        ELSE 0
    END) as assigned___SE,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'SE'
        AND CHARINDEX('rcv applics', siw.WorkflowStatus) > 0
        THEN' 1
        ELSE 0
    END) AS not_assigned___SE,SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'DK'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted > 0
        THEN 1
        ELSE 0
    END) AS completed_exported___DK,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'DK'
        AND CHARINDEX('completed', siw.WorkflowStatus) > 0
        AND si.IsExportCompleted = 0
        THEN 1
        ELSE 0
    END) AS completed___DK,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'DK'
        AND CHARINDEX('assigned', siw.WorkflowStatus) > 0
        THEN 1
        ELSE 0
        END) AS assigned___DK,
    SUM(CASE
        WHEN MystLocations.MystLocationCountry = 'DK'
        AND CHARINDEX('rcv applics', siw.WorkflowStatus) > 0
        THEN' 1
        ELSE 0
        END) as not_assigned___DK
    FROM MystLocations AS ml
INNER JOIN RelDataSurveyInstances AS rdsi
    ON rdsi.MystLocationID = ml.MystLocationID
INNER JOIN SurveyInstances AS si
    ON rdsi.SurveyInstanceID = si.SurveyInstanceID
INNER JOIN ProtoSurveys
    ON ProtoSurveys.ProtoSurveyID = si.ProtoSurveyID
INNER JOIN MystClients
    ON MystClients.MystClientID = ProtoSurveys.ClientID
INNER JOIN MystLocations
    ON MystLocations.MystLocationID = rdsi.MystLocationID
INNER JOIN SurveyInstanceWorkflow AS siw
    ON si.WorkflowStepID = siw.WorkflowStepID
WHERE MystClients.MystClientID = 2410
    AND ( si.TimeStampSurveyDateTimeStart >= '2017-06-23 00:00:00' AND si.TimeStampSurveyDateTimeStart <= '2017-06-23 23:59:59')