You're working with a large dataset containing website user activity, including 'session_id', 'user_id', 'timestamp', and 'page_view'. You suspect bot activity is skewing your engagement metrics. Bots tend to have very short session durations and high page view counts within those sessions. Which of the following Snowflake SQL queries, used in combination, would be MOST effective in identifying and flagging potential bot sessions, considering performance on a large dataset? Assume you have access to Snowflake's statistical functions.