You can have whatever headings you want:
SELECT [Count] = 1, [Market name] = 'Borough Market'
What's important is the column content. Can you explain further? Is it something like this?
SELECT --top 100 percent
f.FormName,
[Market Name] = m.MarketName,
[Count] = COUNT(*) OVER (PARTITION BY (SELECT NULL))
FROM Form f
INNER JOIN FormMarkets_Link l
ON f.FormID = l.ptFormID
INNER JOIN Markets m
ON l.ptMarketID = m.MarketID
CROSS JOIN FormStatus s
WHERE s.FormStatusID = 3
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden