120

WITH compAndDate
AS
(
	SELECT ID_comp,
	CASE
		WHEN time_in < time_out
		THEN DATEADD(dd, 1, time_in) - time_out
		ELSE time_in - time_out
	END AS datediff
	FROM Trip
),
compAndMinutes
AS
(
	SELECT ID_comp,
		DATEPART(hh,datediff) * 60 + DATEPART(mi, datediff) AS 	mi
	FROM compAndDate
)
SELECT POWER(10.0000, SUM(LOG10(1.0*mi))/COUNT(*)) AS GeometricMean
FROM compAndMinutes
GROUP BY ID_comp


https://learnsql.com/blog/high-performance-statistical-queries-sql-part-2-calculating-centers-distribution/