Posted by Kelly, Feb. 12, 2024, 4:46 p.m.

Missing condition? 188. Top 1 popular question by department

It appears that 188's solution missed the following condition listed in the question: 

Rank order the question's popularity by the number of comments on the same day the post was created. 

Comments for each post are counted regardless of the date created.

Also, post_id= 19 has two data entries for post_type = 'question', with two different employee_id. not sure if there is an error or just on purpose. 

Answer

Answers


Comment
SQLPad user: Leon Wei

- Leon (934)

Feb. 17, 2024, 10:32 p.m.