0

Please login or register to vote for this query.

(click on this box to dismiss)

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

select
  p.id as "Post Id",
  title as "Post Title",
  ('=HYPERLINK("http://stackoverflow.com/questions/'+convert(varchar,p.id)+'","'+replace(title,'"','')+'")') 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.CreationDate as "Created",
  p.AcceptedAnswerId as "Answer Accepted?"

from posts p

where

  --p.AcceptedAnswerId is null and
  p.CreationDate >= '20170101' and
  p.CreationDate <= '20170131' and
  p.ClosedDate is null 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;
--order by p.CreationDate desc;

view current version

edited jan 31 17

created may 19 16 karann