instruction: Find tag info by text. This search is case insensitive.. Find tag info by text. This search is case insensitive.
response: SELECT t.TagName, t.Count, p.Id AS "wiki_post_id", 'https://stackoverflow.com/tags/' + t.TagName + '/info' AS "link_to_tag_info" FROM Tags AS t JOIN Posts AS p ON p.Id = t.WikiPostId AND LOWER(p.Body) LIKE '%' + LOWER(@text) + '%' ORDER BY t.Count DESC