queries used to generate run expectancy