instruction: Tags with the highest percentage of closed questions.
response: SELECT tag.TagName AS "tag_name", tag.Count AS "deletion_percentage", p.Id AS "post_link" FROM Tags AS tag INNER JOIN Posts AS p ON p.Tags LIKE CONCAT(CONCAT('%<', tag.TagName COLLATE SQL_Latin1_General_CP1_CI_AS), '>%') AND NOT p.ClosedDate IS NULL GROUP BY p.Id, tag.TagName, tag.Count ORDER BY tag.Count DESC LIMIT 10