Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
select q.id,q.title,q.body, a.score AS "Accepted Score", v.creationdate AS "Accepted Date" from posts q join posts a on q.acceptedanswerid = a.id --- join q's with a's join votes v on a.id = v.postid where q.posttypeid=1 --- questions and q.AcceptedAnswerId IS NOT NULL and v.votetypeid=1 --- accepted by originator and YEAR(v.creationdate)=2024 --- in 2023 ;