Guest User

Untitled

a guest
Dec 11th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT DISTINCT route,
  2. PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY unit_price)
  3. OVER (PARTITION BY route) AS lower_percentil_price_cont,
  4. PERCENTILE_CONT(0.50) WITHIN GROUP (ORDER BY unit_price)
  5. OVER (PARTITION BY route) AS median_price_cont,
  6. PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY unit_price)
  7. OVER (PARTITION BY route) AS upper_percentil_price_cont
  8. FROM airfare_cleared;
Add Comment
Please, Sign In to add comment