79293205

Date: 2024-12-19 05:50:17
Score: 0.5
Natty:
Report link

I found the solution select array_to_string(array_agg(concat(CASE WHEN a.rn = 1 THEN 'NEW' ELSE a.name END,a.name2)),'') from ( select row_number() over() rn,name,name2 from emp) a

Result is :- NEWAnanthaRadhaMeenakshiKolahalanGopal

Reasons:
  • Whitelisted phrase (-2): I found the solution
  • Low length (0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Gopal.anant