Q&A for Ubuntu users and developers
SELECT Top 10 NEWID() Random, * FROM Posts p WHERE p.Score>100 AND p.ViewCount>10000 ORDER BY Random