instruction: Questions Where Highest Voted Answer Exceeds Accepted Answer and OP's Account Is Deleted. Grabs all questions asked by users who no longer exist and selects the ones where the highest voted answer is NOT the accepted answer. I'm sure this query could be optimized.
response: WITH questions AS (SELECT question.Id, question.ViewCount, accepted.Score AS AcceptedScore, (SELECT MAX(Score) FROM Posts WHERE ParentId = question.Id AND question.AcceptedAnswerId != Id) AS HighestScore FROM Posts AS question, Posts AS accepted WHERE question.AcceptedAnswerId = accepted.Id AND question.PostTypeId = 1 AND question.OwnerUserId IS NULL) SELECT Id AS "post_link", ViewCount AS "view_count", AcceptedScore AS "score_of_accepted_answer", HighestScore AS "score_of_highest_voted_answer" FROM questions WHERE HighestScore > AcceptedScore AND ViewCount > 1000 ORDER BY ViewCount DESC