URI SQL Solution 2740 - League

Written by   on   in   with 3 comments
(select concat('Podium: ',team)as name
from league
order by position
limit 3)
union all
(select concat('Demoted: ',team)as name
from league
where position>any(select count(*)-2 from league))
Share:

3 comments:

  1. BijoyJanuary 19, 2019 at 4:28 AM

    This comment has been removed by the author.

    ReplyDelete
  2. BijoyJanuary 19, 2019 at 4:28 AM

    thanks

    ReplyDelete
  3. MAHIBIAApril 2, 2022 at 3:31 AM

    (select concat('Podium: ',team) as name from league
    where position in (select position from league order by position limit 3))
    union all
    (select concat('Demoted: ',team) as name from league
    where position in (select position from league order by position desc limit 2))

    ReplyDelete