Stack exchange site query https://data.stackexchange.com/stackoverflow/query/edit/1041819, https://data.stackexchange.com/stackoverflow/query/edit/1043304

query.sql

/* Date of execution: Sat  4 May 23:57:05 +06 2019*/

/* Number of questions with Flask tag: 30115 */
SELECT COUNT(Id) FROM Posts WHERE Tags LIKE '%flask%';


/* Number of questions with accepted answer with Flask tag: 15991 */
SELECT COUNT(Id) FROM Posts WHERE Tags LIKE '%flask%' and AcceptedAnswerId IS NULL;


/* Number of questions without accepted answer with Flask tag: 14124 */
SELECT COUNT(Id) FROM Posts WHERE Tags LIKE '%flask%' and AcceptedAnswerId IS NOT NULL;


/* Top 10 most viewed question with accepted answer in Flask tag */
SELECT TOP(10)
  Title, Body 
  FROM Posts 
  WHERE Tags LIKE '%flask%' and 
  AcceptedAnswerId IS NOT NULL 
  ORDER BY ViewCount DESC;
  
  
/*
All questions with accepted answers in Flask tag sorted by view count
Query URL: https://data.stackexchange.com/stackoverflow/query/1043309/all-questions-with-accepted-answers-in-flask-tag-sorted-by-view-count
*/
SELECT * 
  FROM Posts 
  WHERE Tags LIKE '%flask%' and 
  AcceptedAnswerId IS NOT NULL 
  ORDER BY ViewCount DESC;