0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 28

created nov 28 anonymous