WITH CTE_TakingJourneysInfo(JourneyId,JourneyDiffs)
AS
(
SELECT
    j.Id
    ,DATEDIFF(minute,j.JourneyStart,j.JourneyEnd) AS Diff
FROM
    Journeys AS j
),
CTE_TakingMaxDiff (MaxDiff)
AS
(
SELECT
    MAX(JourneyDiffs)
FROM
    CTE_TakingJourneysInfo AS cte
),
CTE_TakingTheLongestJourneyId (LongestJourneyId)
AS
(
SELECT
    CTE_TakingJourneysInfo.JourneyId
FROM
    CTE_TakingMaxDiff
    ,CTE_TakingJourneysInfo
WHERE
    CTE_TakingJourneysInfo.JourneyDiffs = CTE_TakingMaxDiff.MaxDiff
),
CTE_TakingInfoAboutTheColonistCountPerJob(JobName,ColonistsCount)
AS
(
SELECT
    tc.JobDuringJourney
    ,COUNT(tc.ColonistId)
FROM
    TravelCards AS tc
INNER JOIN
    CTE_TakingTheLongestJourneyId AS ttlji
ON
    tc.JourneyId = ttlji.LongestJourneyId
WHERE
    tc.JourneyId = ttlji.LongestJourneyId
GROUP BY tc.JobDuringJourney
)
SELECT TOP(1)
    LongestJourneyId
    ,JobName
FROM
    CTE_TakingInfoAboutTheColonistCountPerJob
    ,CTE_TakingTheLongestJourneyId
ORDER BY ColonistsCount ASC