Q&A for professionals and students of engineering
SELECT Q.Id AS [Post Link], Q.Score FROM Posts Q WHERE -- Post is question Q.PostTypeId = 1 -- Question is a code-golf challenge and not any of: -- tips, restricted-any, source-layout, quine, polyglot, cops-and-robbers -- ascii-art, kolmogorov-complexity, internet, network, compile-time, regex -- graphical-output, image AND Q.Tags LIKE '%code-golf%' AND Q.Tags NOT LIKE '%tips%' AND Q.Tags NOT LIKE '%restricted%' AND Q.Tags NOT LIKE '%source-layout%' AND Q.Tags NOT LIKE '%quine%' AND Q.Tags NOT LIKE '%polyglot%' AND Q.Tags NOT LIKE '%cops%' AND Q.Tags NOT LIKE '%ascii-art%' AND Q.Tags NOT LIKE '%kolmogorov%' AND Q.Tags NOT LIKE '%internet%' AND Q.Tags NOT LIKE '%network%' AND Q.Tags NOT LIKE '%hardware%' AND Q.Tags NOT LIKE '%compile%' AND Q.Tags NOT LIKE '%regular%' AND Q.Tags NOT LIKE '%regex%' AND Q.Tags NOT LIKE '%graphical%' AND Q.Tags NOT LIKE '%image%' -- Question was asked between 2016 and 2018 AND year(Q.CreationDate) <= 2018 AND year(Q.CreationDate) >= 2016 -- Positive score AND Q.Score >= 1 -- Not too hard, at least two answers AND 2 <= Q.AnswerCount -- No answers in any variant of APL, excluding Perl/Ruby -apl answers AND NOT EXISTS ( SELECT * FROM Posts A WHERE A.ParentId = Q.Id AND A.PostTypeId = 2 AND A.Body LIKE '%APL%' AND A.Body NOT LIKE '%-APL%' ) ORDER BY len(Q.Tags) DESC, Q.Score DESC