Table: ci_rosal_a_de
Columns: season
tier
division
pos
postseason
cup_competitions

Question: Which tier has a division of LEB 2 and Cup Competitions of Copa LEB Plata runner-up?
SQL: SELECT "tier" FROM ci_rosal_a_de WHERE "division" = 'leb 2' AND "cup_competitions" = 'copa leb plata runner-up'

Question: How many positions have a Postseason of relegation playoffs and a tier of 3?
SQL: SELECT COUNT("pos") FROM ci_rosal_a_de WHERE "postseason" = 'relegation playoffs' AND "tier" = 3

Question: What is the lowest tier for a postseason result of quarterfinalist?
SQL: SELECT MIN("tier") FROM ci_rosal_a_de WHERE "postseason" = 'quarterfinalist'