Skip to content

Instantly share code, notes, and snippets.

View tparveen's full-sized avatar

Tauhida Parveen tparveen

View GitHub Profile
  1. What are the three longest trips on rainy days?
WITH rainy as 
(
SELECT 
DATE(date) rain_date
From weather
WHERE events = 'Rain'
GROUP BY 1
)