The following query displays select fields from the Users table. Modify the query to display the users ordered by decreasing reputation.
Q&A for engineers, scientists, programmers, and computing professionals interested in quantum computing
select top(10) p.id, p.title, p.tags, len(p.tags) - len(replace(p.tags, '<','')) as TagCount, ptype.name from posts p left join posttypes ptype on p.PostTypeId = ptype.id where ptype.name = 'Question' ;