Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer, you are tasked with analyzing website visitor data to optimize content strategy. The dataset includes visitor's country, page visited, and time spent on the page. Your goal is to identify which pages are most engaging for visitors from a specific country, considering both the total time spent and the average time spent per visit to ensure content relevance and engagement. Choose the SQL query that best retrieves the total time spent on each page by visitors from 'USA', along with the page name, and also considers the average time spent to provide a comprehensive view of engagement. Select one option.