Hello SQL

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results