Q&A for enthusiasts and power users of the Android operating system
p.id as [Post Link],
p.tags as Tags,
p.ViewCount as "Views",
p.score as "Score",
p.AnswerCount as "Answers",
DATEDIFF(day,p.CreationDate,getdate()) as "Age (days)",
p.AcceptedAnswerId as "Answer Accepted?"
from posts p
--p.AcceptedAnswerId is null and
p.CreationDate >= '20160531' and
p.tags like '%<uwp>%' or p.tags like '%<windows-10-universal>%'
(p.tags like '%<xaml>%' and p.tags like '%<windows-10>%')
order by p.viewcount desc;