Spam/offensive flags on CGCC

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges

Q&A for programming puzzle enthusiasts and code golfers

select
  case
    when VoteTypeId =  4 then 'Offensive Flag'
    when VoteTypeId = 12 then 'Spam Flag'
  end as [Flag Type],
  CreationDate
from
  Votes
where
  VoteTypeId in (4, 12)
order by
  CreationDate
   desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results