$($i$)$ Environment

$$ SELECT

city,

GROUP$\_$CONCAT $($name ORDER BY name$)$ AS players,

CONCAT $(\text{'}$Team$\text{'},$ team$\_$number$)$ AS team$\_$name

$$ FROM $($

$$ SELECT

city,

name,

$($ROW$\_$NUMBER$()$ OVER $($PARTITION BY city ORDER BY name$)-1)\%$

$3+1$ AS team$\_$number

FROM emp$\_$details

$x$

GROUP BY city, team$\_$number

ORDER BY city, team$\_$number

LIMIT $20$;