Added queries for daily and weekly reports