A query to look for questions that contain a SINGLE tag - something that can't be achieved with the native search tools on the Stack Overflow site.
This example returns the top 10 questions, sorted by the last activity date.
Q&A for professional and enthusiast programmers
DECLARE @tag nvarchar(250)
-- Choose which tag you want to search for here:
SET @tag = 'java'
SELECT TOP 10 Id AS [Post Link], Tags
WHERE Tags = '<' + @tag + '>' AND PostTypeId = 1
ORDER BY LastActivityDate Desc