task post answer rate for a specific tag
Q&A for biology researchers, academics, and students
-- Some Basic details:
SELECT top 40 count(id), count(AcceptedAnswerID), CAST(count(AcceptedAnswerID) as float) / count(id) as rate
WHERE (Tags like '%klipfolio%'
or Tags like '%alteryx%'
or Tags like '%tableau%'
or Tags like '%qlik%'
or Tags like '%knime%'
or Tags like '%powerbi%'
-- Step 2:
-- Find the answer rate, and Accepted Answer Rate for Posts tagged with "Tableau"
-- Step 3:
-- Of those with an accepted answer, how many are answered by the user who asked
-- the question?