How to write sql statement for following scenario?
You need to use three things


GROUP BY
GROUP_CONCAT
DISTINCT within GROUP_CONCAT


Here is such a query

Select room_no, group_concat(distinct category) categories
from help_desk where room_no in (133,120) group by room_no;