Statistics

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

/*select top p.PostTypeId, 
Prog_Language as 
from Posts as p
where Tags = '<c#>' or Tags = '<java>'
*/
--select * from PostTypes

select
      p.Title,
      IIF(p.Tags like '%c#%', 'C#', 'Java') as Language,
      p.CreationDate,
      p.Score,
      p.ClosedDate,
      u.DisplayName as UserName
from Posts as p, Users as u
where (Tags like '%<c#>%' or Tags like '%<java>%')
  and PostTypeId = 1
  and Year(p.CreationDate) = 2012 
  and Month(p.CreationDate) = 10
  and u.Id = p.OwnerUserId
  and p.ClosedDate IS NOT NULL

Enter Parameters

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