SELECT
	DATE(t.start_date),
	t.trip_id,
	t.duration
FROM
	trips t
JOIN
	weather w
ON
	DATE(t.start_date) = DATE(w.date)
WHERE
	w.precipitationin > 0
ORDER BY
	t.duration desc
LIMIT 3