Q&A for scientists using computers to solve scientific problems
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 ;