instruction: Average number of answers depending on the weekday when the question was posted.
response: WITH tmp AS (SELECT AnswerCount AS ACount, Period = TIME_TO_STR(CreationDate, '%W') FROM Posts WHERE PostTypeId = 1) SELECT Period, AVG(CAST(ACount AS FLOAT)) FROM tmp GROUP BY Period ORDER BY Period