TEXT   36
Select Avg
Guest on 15th March 2023 02:30:22 AM


  1. Select Avg(Number) as Median from (
  2. Select max(Rank) Number from Beers B
  3. where (Select Count(*) from Beers where Rank < B.Rank) < (Select
  4. (Count(Rank) + (Count(Rank) % 2)) /2 from Beers)
  5. union all
  6. Select min(Rank) Number from Beers B
  7. where (Select Count(*) from Beers where Rank < B.Rank) > (Select
  8. (Count(Rank) + (Count(Rank) % 2)) /2 from Beers)) A
Raw Paste

Login or Register to edit or fork this paste. It's free.