with email_filter AS (SELECT policyId,
                             ROW_NUMBER() OVER (PARTITION BY COALESCE(insuredEmail, insurerEmail,
                                                                      customerEmail) ORDER BY policyId ASC) AS rownum
                      FROM dbo.AllDataView)

SELECT v.policyId,
       v.status,
       v.agentCode,
       v.beginDate,
       v.endDate,
       CONCAT(insuredLastName, ' ', insuredFirstName, ' ', insuredPatronymic) AS passenger,
       COALESCE(insuredEmail, insurerEmail, customerEmail)                    AS email
FROM email_filter ef
    inner join dbo.AllDataView  v on v.policyId = ef.policyId
WHERE v.beginDate >= CONVERT(datetime, '01.04.2019', 104)
  AND v.productType IN ('AIR', 'TRAVEL_AIR', 'AMADEUS_AIR', 'AMADEUS_TRAVEL_AIR')
  AND v.status = 'CONFIRMED'
  AND CAST(v.beginDate AS date) =
      CAST((SELECT TOP 1 value FROM STRING_SPLIT(segmentDepartureDate, ';') ORDER BY value) AS date)
  AND CAST(v.endDate AS date) =
      CAST((SELECT TOP 1 value FROM STRING_SPLIT(segmentArrivalDate, ';') ORDER BY value DESC) AS date)
  AND v.rownum = 1;