A list of questions with a high score and low view count
Q&A for students, teachers, and linguists wanting to discuss the finer points of the French language
-- Enter Query Title -- Enter Query Description Select p1.Id as Q_Id, p2.Id as A_Id, p1.Body as Q_Body, p2.Body as A_Body, p2.ParentId as A_ParentId, p1.AcceptedAnswerId as Q_AcceptedAnswerId, 'false' as isExecuted, p1.Tags as Q_Tag, p1.CreationDate as Q_CreationDate, p2.CreationDate as A_CreationDate, p1.Score as Q_Score, p2.Score as A_Score, p1.ViewCount as Q_ViewCount, p1.Title as Q_Title, p1.AnswerCount as Q_AnswerCount, p1.ClosedDate as Q_ClosedDate, p1.PostTypeId as Q_PostTypeId, p2.PostTypeId as A_PostTypeId, p1.OwnerUserId as Q_OwnerUserId, p2.OwnerUserId as A_OwnerUserId, p1.OwnerDisplayName as Q_OwnerDisplayName, p2.OwnerDisplayName as A_OwnerDisplayName, p1.FavoriteCount as Q_FavoriteCount, p1.ContentLicense as Q_ContentLicense, p2.ContentLicense as A_ContentLicense from Posts p1 Inner join Posts p2 on p1.Id = P2.ParentId where p1.Score >=2 and p1.Id > 56727980 and p1.Id < 60000000 and p1.PostTypeId = 1 and p2.PostTypeId = 2 and (p1.Tags like '%spring%' or p1.Tags like '%java%' or p1.Tags like '%python%' or p1.Tags like '%c%' or p1.Tags like '%c++%' or p1.Tags like '%javascript%' or p1.Tags like '%c#%' or p1.Tags like '%php%' or p1.Tags like '%angular%' or p1.Tags like '%react%' or p1.Tags like '%node%' or p1.Tags like '%aws%' or p1.Tags like '%jquery%' or p1.Tags like '%html%' or p1.Tags like '%css%' or p1.Tags like '%android%' or p1.Tags like '%typescript%' or p1.Tags like '%sql%' or p1.Tags like '%xml%' or p1.Tags like '%mongo%' or p1.Tags like '%api%' or p1.Tags like '%jpa%' or p1.Tags like '%hibernate%' or p1.Tags like '%kotlin%' or p1.Tags like '%r%' or p1.Tags like '%swift%' or p1.Tags like '%blockchain%' or p1.Tags like '%artificial%' or p1.Tags like '%ruby%' or p1.Tags like '%thread%' or p1.Tags like '%oops%' or p1.Tags like '%elastic%' or p1.Tags like '%jsp%' or p1.Tags like '%code%' or p1.Tags like '%google%' or p1.Tags like '%jsp%' or p1.Tags like '%session%' or p1.Tags like '%npm%' or p1.Tags like '%jdbc%' or p1.Tags like '%woocommerce%' or p1.Tags like '%struct%' or p1.Tags like '%Bootstrap%' or p1.Tags like '%net%') order by p1.Id asc