Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
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 ;