March 14 - Apr 30, 2023 - all questions, their upvotes and downvotes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

SELECT 
    q.Id AS QuestionID,
    q.CreationDate,
    q.Score AS NetScore,
    (SELECT COUNT(*) FROM Votes AS v WHERE v.PostId = q.Id AND v.VoteTypeId = 2) AS Upvotes,
    (SELECT COUNT(*) FROM Votes AS v WHERE v.PostId = q.Id AND v.VoteTypeId = 3) AS Downvotes
FROM 
    Posts AS q
WHERE 
    q.PostTypeId = 1 -- Only questions
    AND q.CreationDate BETWEEN '2024-03-14' AND '2024-03-28'
ORDER BY 
    q.CreationDate;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results