How Can I Group Each Promotion Isroi Values And Compare Them(Each Promotion Id Is_Roi Values)

See more:

SQL

server

I have to columns ...
promotionid isroi
12 y
12 N
13 n
14 y
15 n
15 n
16 n
16 n
16 n
16 y

Promotion Type column should display the type of the Promotion.
If the Promotion has at least one Investment Type that is configured as IsROI=y then Promotion Type will be “ROI”. If the Promotion has all 'n' values then it has to display 'NONROI'= False”.


Output will be

promotion_id promotion_type
12 ROI
13 NONROI
14 ROI
15 NOROI
16 ROI