Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

--Question 3:
-- Select from the Posts table the Title, Id, Score and ViewCount and DisplayName from the Users table by joining Posts and Users by their ID. Restrict the values so that the PostTypeId is 1, the score is greater than 50, and the title contains the word “triangle” . Order the results by User reputation in descending order.SQL

SELECT Posts.PostTypeId, Posts.Title, Posts.Id, Posts.Score, Posts.ViewCount, Users.DisplayName
FROM Posts
JOIN Users ON Posts.OwnerUserId = Users.Id
WHERE --Posts.PostTypeId = 1
 Posts.Score >= 15

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results