I am basically a C programmer but I started on SQL today with the only purpose of fiddling around the data available on data.stackexchange.com. So please bear with me if my question is naive or unclear. I wrote a query to find out Popular Questions on SO based on view count
Select OwnerUserId As [User Link], Id As [Post Link], ViewCount As [Total Number of Views] From Posts Where ViewCount > 10000 Order By ViewCount Desc
The problem I am facing here is if I change
[Post Link] to
[Popular Question] or
[User Link] to something more desirable like
[Asker], the hyper-links linking to the question and the user receptively don't appear. Only IDs of users and Posts like
457237(my user id),
145275(this question ID) appear. If I understand correctly
AS is just an
So how is that
[Post Link] produces a hyperlink and
[Link to the Question] or something else doesn't?
Is it something specific to data.stackexchange?