Cahoot-Interview-Project

第1部分：我无法完成这项工作的服务器部分，但是静态PWA客户端位于： 第2部分： SELECT dow, SUM (Vote_Count) as Votes, SUM (Answer_Count) as Answers, Vote_Type FROM ( SELECT DATENAME(dw, P . CreationDate ) as dow, COUNT ( VT . Name ) as Vote_Count, Count (AnswerCount) as Answer_Count, VT . Name as Vote_Type, Type as Post_Type FROM dbo . Posts P INNER JOIN dbo . PostTypes PT ON P . PostTypeId = PT . Id INNER JOIN dbo . Votes V