0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- SELECT *
-- FROM Posts
-- ORDER BY ViewCount desc
--SELECT * 
--FROM Posts
--WHERE ViewCount = (SELECT Top 10 ViewCount
                   --FROM Posts
                   --ORDER BY ViewCount desc)
--AND
--Score > 1

SELECT Id, CreationDate,
'hot countries' = CASE WHEN location like '%china%' then 'user from china'
                       WHEN location like '%singapore%' then 'user from singapore'
                       WHEN location like '%norway%' then 'user from norway'
                       WHEN location like '%australia%' then 'user from australia'
                       ELSE 'others'
                       END
                       
FROM Users

fork query

edited mar 22

created mar 22 anonymous