Test 11-24-13 AL

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A about the site for scientists using computers to solve scientific problems

SELECT 
  Questions.CreationDate as "Q.Date", 
  Questions.Score as "Q.Score", 
  Questions.ViewCount as "Q.Views", 
  Questions.Title as "Q.Title", 
  Questions.Body as "Q.Body", 
  Questions.Tags as "Q.Tags", 
  Questions.AnswerCount as "Q.AnswerCount", 
  Users.Reputation as "U.Rep",
  Users.Location as "U.Loc",
  Users.Views as "U.Views",
  Users.UpVotes as "U.Upvotes",
  Users.DownVotes as "U.Downvotes",
  Users.Age as "U.Age",
  Answers.CreationDate as "A.Date"
FROM 
  Posts Questions
 JOIN
  Users ON Users.Id = Questions.OwnerUserId
 JOIN
  Posts Answers ON Answers.Id = Questions.AcceptedAnswerId

Enter Parameters

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