Show all values in known tables that map a type id to a type name.
Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam
-- Show types
-- Show all values in known tables that map a type id to a type name.
--SELECT year(creationdate),count(*) from posts group by year(creationdate);
q.id as QuestionID, q.body as QuestionBody,
a.id as AnswerID, a.body as AnswerBody
from posts q
join posts a on q.id = a.parentid and a.posttypeid=2
where q.creationdate between '01/01/2020 00:00:00' and '1/3/2020 23:59:59'
and q.posttypeid= 1