Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
CASE Votes.VoteTypeId WHEN 2 THEN 1 ELSE 0 END upvotes,
- CASE Votes.VoteTypeId WHEN 3 THEN 1 ELSE 0 END downvotes,
INNER JOIN Users ON Users.ID = Posts.OwnerUserId
INNER Join Votes ON Votes.PostId = Posts.Id
WHERE PostTypeId = 1
AND Posts.CreationDate BETWEEN '2012-01-28' AND '2012-02-27'
AND Users.DisplayName = 'Izkata'
AND Posts.Title = 'Did Daniel Jackson ever actually die?'