0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

SELECT U1.Id,

       U1.DisplayName,

       U1.Location

FROM Users U1 LEFT JOIN Users U2
ON U1.Location=U2.Location

WHERE U1.Location LIKE '%new%'

ORDER BY U1.Location, U1.DisplayName, U1.Id

fork query

edited oct 22 17

created oct 22 17 anonymous