Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
select id , cast(creationdate as date) as cdate , posttypeid , deletiondate - creationdate , case when (deletiondate <= '2023-12-03' and parentid is not null) then 'Ans' when (deletiondate <= '2023-12-03' and parentid is null) then 'Que' else 'Ali' end as dreason from postswithdeleted where creationdate<= '2023-12-03' and posttypeid in ('1', '2') and deletiondate is not null ;