0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

Select 
P.Id,
P.Title, 
P.CreationDate,
P.ViewCount,
P.Tags,
U.DisplayName AS OwnerUserName,
U1.DisplayName AS AcceptedAnswerUser

From Posts AS P

Left Join Comments AS C ON P.AcceptedAnswerId = C.Id
Left Join Users AS U1 ON U1.Id = C.UserId
Left Join Users AS U ON P.OwnerUserId = U.Id

Where P.CreationDate > '11/30/2017'
And P.Tags like '%marketing-cloud%'
And ViewCount > 1000

Order By P.ViewCount Desc

fork query

edited nov 30

created nov 30 anonymous