0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, researchers and practitioners of computer science

select Id,CreationDate,
'hot countries' = case
                    when location like '%china%' then 'user coming from China'
                    when location like '%India%' then 'user coming from India'
                    when location like '%Vietnam%' then 'user coming from Vietnam'
                    when location like '%Singapore%' then 'user coming from Singapore'
                    else 'user coming from other countries'
end
from Users

fork query

edited mar 22

created mar 22 anonymous