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