UWP top open questions since May1, 2016 by viewcount

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

select
  p.id as [Post Link],
  title,
  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

where

  p.AcceptedAnswerId is null and
  p.CreationDate >= '20160501' and

  (
    p.tags like '%<uwp>%' or p.tags like '%<windows-10-universal>%'
    or
    (p.tags like '%<xaml>%' and p.tags like '%<windows-10>%')
  )


order by p.viewcount desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results