instruction: Not so hidden gems: Highest score for questions with less than 10,000 views.
response: SELECT Posts.Id AS "post_link", Posts.OwnerUserId AS "user_link", Score, ViewCount, Score * 1000 / ViewCount AS "Score per Thousand Views" FROM Posts WHERE ViewCount < 10000 AND PostTypeId = 1 ORDER BY Score DESC LIMIT 1000