0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Korean language

select 
a1.OwnerUserId, a1.Score, a1.ViewCount, b1.Score as 'B1 score', b1.ViewCount as 'B1 View'
from Posts a1
inner join Posts b1 on a1.OwnerUserId=b1.OwnerUserId 
and b1.Score = 0
and b1.ViewCount = 527
where a1.ViewCount = 527
and a1.OwnerUserId = 38
order by OwnerUserId;

fork query

edited mar 20

created mar 17 anonymous