Contest Entry

--------------------------------------------------------------

Recommendation For Query#1 and @Query#2

--------------------------------------------------------------

Understanding: It seems that AnalysisLog table used to keep count of clicks on each artical(data) date wise.

Logical Change Recommended : first execute Update query to...