Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT route,
- PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY unit_price)
- OVER (PARTITION BY route) AS lower_percentil_price_cont,
- PERCENTILE_CONT(0.50) WITHIN GROUP (ORDER BY unit_price)
- OVER (PARTITION BY route) AS median_price_cont,
- PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY unit_price)
- OVER (PARTITION BY route) AS upper_percentil_price_cont
- FROM airfare_cleared;
Add Comment
Please, Sign In to add comment