Close rate for questions with a given phrase in the title

0

Please login or register to vote for this query.

(click on this box to dismiss)

searches for exact phrase, case-insensitive

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

-- Close rate for questions with a given phrase in the title
-- searches for exact phrase, case-insensitive

SELECT
    COUNT(*) [Total Posts],
    COUNT(ClosedDate) [Closed Posts],
    100.0 * COUNT(ClosedDate) / count(*) as [Close Rate]
FROM posts
where
lower(title) like '%' + ##phrase:string## + '%'
and posttypeid = 1

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results